AirBNB Seattle Data Analysis

Introduction:

This project is to demonstrate the understanding of data science process and to apply it real data set.
The data set I chose is provided by AirBNB, the house sharing company for the West Coast City of Seattle,
I will follow CRISP-DM process in the analysis of this data set.

Data Sets:

The data is divided in three files:

  • calendar.csv - containing listing prices and data about availability
  • listings.csv - the main data file, which contains detailed features about each listing
  • reviews.csv - records for listing reviews

Business understanding:

The data have many features to analyze, I will choose the ones related to customers and neighborhoods.
I will do some data exploration and visualizations to answer the following questions:
Q1: Are Customers Happy?
Q2: Where listings are concentrated?
Q3: How much the customer is paying to stay in Seattle with AirBNB?
Q4: What are the average prices for each neighborhood?

In [1]:
# import libraries here; add more as necessary
import numpy as np
import pandas as pd
import math
import json
import pickle
from datetime import datetime as dt
from IPython.display import display, HTML
import plotly
import re
import ast




import sys
np.set_printoptions(threshold=sys.maxsize)
print(sys.version)

pd.set_option('display.max_columns', 500)
import chart_studio as py
import plotly.graph_objects as go
import plotly.io as pio
import plotly.express as px
3.7.3 (default, Mar 27 2019, 22:11:17) 
[GCC 7.3.0]

Data understanding:

Here I will load each of the files and do some exploration

In [2]:
# read in the csv files
calendar = pd.read_csv('calendar.csv')
listings = pd.read_csv('listings.csv')
reviews = pd.read_csv('reviews.csv')
In [3]:
calendar
Out[3]:
listing_id date available price
0 241032 2016-01-04 t $85.00
1 241032 2016-01-05 t $85.00
2 241032 2016-01-06 f NaN
3 241032 2016-01-07 f NaN
4 241032 2016-01-08 f NaN
5 241032 2016-01-09 f NaN
6 241032 2016-01-10 f NaN
7 241032 2016-01-11 f NaN
8 241032 2016-01-12 f NaN
9 241032 2016-01-13 t $85.00
10 241032 2016-01-14 t $85.00
11 241032 2016-01-15 f NaN
12 241032 2016-01-16 f NaN
13 241032 2016-01-17 f NaN
14 241032 2016-01-18 t $85.00
15 241032 2016-01-19 t $85.00
16 241032 2016-01-20 t $85.00
17 241032 2016-01-21 f NaN
18 241032 2016-01-22 f NaN
19 241032 2016-01-23 f NaN
20 241032 2016-01-24 t $85.00
21 241032 2016-01-25 t $85.00
22 241032 2016-01-26 t $85.00
23 241032 2016-01-27 t $85.00
24 241032 2016-01-28 t $85.00
25 241032 2016-01-29 f NaN
26 241032 2016-01-30 f NaN
27 241032 2016-01-31 f NaN
28 241032 2016-02-01 t $85.00
29 241032 2016-02-02 t $85.00
... ... ... ... ...
1393540 10208623 2016-12-04 f NaN
1393541 10208623 2016-12-05 f NaN
1393542 10208623 2016-12-06 f NaN
1393543 10208623 2016-12-07 f NaN
1393544 10208623 2016-12-08 f NaN
1393545 10208623 2016-12-09 f NaN
1393546 10208623 2016-12-10 f NaN
1393547 10208623 2016-12-11 f NaN
1393548 10208623 2016-12-12 f NaN
1393549 10208623 2016-12-13 f NaN
1393550 10208623 2016-12-14 f NaN
1393551 10208623 2016-12-15 f NaN
1393552 10208623 2016-12-16 f NaN
1393553 10208623 2016-12-17 f NaN
1393554 10208623 2016-12-18 f NaN
1393555 10208623 2016-12-19 f NaN
1393556 10208623 2016-12-20 f NaN
1393557 10208623 2016-12-21 f NaN
1393558 10208623 2016-12-22 f NaN
1393559 10208623 2016-12-23 f NaN
1393560 10208623 2016-12-24 f NaN
1393561 10208623 2016-12-25 f NaN
1393562 10208623 2016-12-26 f NaN
1393563 10208623 2016-12-27 f NaN
1393564 10208623 2016-12-28 f NaN
1393565 10208623 2016-12-29 f NaN
1393566 10208623 2016-12-30 f NaN
1393567 10208623 2016-12-31 f NaN
1393568 10208623 2017-01-01 f NaN
1393569 10208623 2017-01-02 f NaN

1393570 rows × 4 columns

In [4]:
listings
Out[4]:
id listing_url scrape_id last_scraped name summary space description experiences_offered neighborhood_overview notes transit thumbnail_url medium_url picture_url xl_picture_url host_id host_url host_name host_since host_location host_about host_response_time host_response_rate host_acceptance_rate host_is_superhost host_thumbnail_url host_picture_url host_neighbourhood host_listings_count host_total_listings_count host_verifications host_has_profile_pic host_identity_verified street neighbourhood neighbourhood_cleansed neighbourhood_group_cleansed city state zipcode market smart_location country_code country latitude longitude is_location_exact property_type room_type accommodates bathrooms bedrooms beds bed_type amenities square_feet price weekly_price monthly_price security_deposit cleaning_fee guests_included extra_people minimum_nights maximum_nights calendar_updated has_availability availability_30 availability_60 availability_90 availability_365 calendar_last_scraped number_of_reviews first_review last_review review_scores_rating review_scores_accuracy review_scores_cleanliness review_scores_checkin review_scores_communication review_scores_location review_scores_value requires_license license jurisdiction_names instant_bookable cancellation_policy require_guest_profile_picture require_guest_phone_verification calculated_host_listings_count reviews_per_month
0 241032 https://www.airbnb.com/rooms/241032 20160104002432 2016-01-04 Stylish Queen Anne Apartment NaN Make your self at home in this charming one-be... Make your self at home in this charming one-be... none NaN NaN NaN NaN NaN https://a1.muscache.com/ac/pictures/67560560/c... NaN 956883 https://www.airbnb.com/users/show/956883 Maija 2011-08-11 Seattle, Washington, United States I am an artist, interior designer, and run a s... within a few hours 96% 100% f https://a0.muscache.com/ac/users/956883/profil... https://a0.muscache.com/ac/users/956883/profil... Queen Anne 3.0 3.0 ['email', 'phone', 'reviews', 'kba'] t t Gilman Dr W, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.636289 -122.371025 t Apartment Entire home/apt 4 1.0 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $85.00 NaN NaN NaN NaN 2 $5.00 1 365 4 weeks ago t 14 41 71 346 2016-01-04 207 2011-11-01 2016-01-02 95.0 10.0 10.0 10.0 10.0 9.0 10.0 f NaN WASHINGTON f moderate f f 2 4.07
1 953595 https://www.airbnb.com/rooms/953595 20160104002432 2016-01-04 Bright & Airy Queen Anne Apartment Chemically sensitive? We've removed the irrita... Beautiful, hypoallergenic apartment in an extr... Chemically sensitive? We've removed the irrita... none Queen Anne is a wonderful, truly functional vi... What's up with the free pillows? Our home was... Convenient bus stops are just down the block, ... https://a0.muscache.com/ac/pictures/14409893/f... https://a0.muscache.com/im/pictures/14409893/f... https://a0.muscache.com/ac/pictures/14409893/f... https://a0.muscache.com/ac/pictures/14409893/f... 5177328 https://www.airbnb.com/users/show/5177328 Andrea 2013-02-21 Seattle, Washington, United States Living east coast/left coast/overseas. Time i... within an hour 98% 100% t https://a0.muscache.com/ac/users/5177328/profi... https://a0.muscache.com/ac/users/5177328/profi... Queen Anne 6.0 6.0 ['email', 'phone', 'facebook', 'linkedin', 're... t t 7th Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.639123 -122.365666 t Apartment Entire home/apt 4 1.0 1.0 1.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,"Free... NaN $150.00 $1,000.00 $3,000.00 $100.00 $40.00 1 $0.00 2 90 today t 13 13 16 291 2016-01-04 43 2013-08-19 2015-12-29 96.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict t t 6 1.48
2 3308979 https://www.airbnb.com/rooms/3308979 20160104002432 2016-01-04 New Modern House-Amazing water view New modern house built in 2013. Spectacular s... Our house is modern, light and fresh with a wa... New modern house built in 2013. Spectacular s... none Upper Queen Anne is a charming neighborhood fu... Our house is located just 5 short blocks to To... A bus stop is just 2 blocks away. Easy bus a... NaN NaN https://a2.muscache.com/ac/pictures/b4324e0f-a... NaN 16708587 https://www.airbnb.com/users/show/16708587 Jill 2014-06-12 Seattle, Washington, United States i love living in Seattle. i grew up in the mi... within a few hours 67% 100% f https://a1.muscache.com/ac/users/16708587/prof... https://a1.muscache.com/ac/users/16708587/prof... Queen Anne 2.0 2.0 ['email', 'phone', 'google', 'reviews', 'jumio'] t t West Lee Street, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.629724 -122.369483 t House Entire home/apt 11 4.5 5.0 7.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $975.00 NaN NaN $1,000.00 $300.00 10 $25.00 4 30 5 weeks ago t 1 6 17 220 2016-01-04 20 2014-07-30 2015-09-03 97.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 2 1.15
3 7421966 https://www.airbnb.com/rooms/7421966 20160104002432 2016-01-04 Queen Anne Chateau A charming apartment that sits atop Queen Anne... NaN A charming apartment that sits atop Queen Anne... none NaN NaN NaN NaN NaN https://a0.muscache.com/ac/pictures/94146944/6... NaN 9851441 https://www.airbnb.com/users/show/9851441 Emily 2013-11-06 Seattle, Washington, United States NaN NaN NaN NaN f https://a2.muscache.com/ac/users/9851441/profi... https://a2.muscache.com/ac/users/9851441/profi... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'jum... t t 8th Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.638473 -122.369279 t Apartment Entire home/apt 3 1.0 0.0 2.0 Real Bed {Internet,"Wireless Internet",Kitchen,"Indoor ... NaN $100.00 $650.00 $2,300.00 NaN NaN 1 $0.00 1 1125 6 months ago t 0 0 0 143 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f flexible f f 1 NaN
4 278830 https://www.airbnb.com/rooms/278830 20160104002432 2016-01-04 Charming craftsman 3 bdm house Cozy family craftman house in beautiful neighb... Cozy family craftman house in beautiful neighb... Cozy family craftman house in beautiful neighb... none We are in the beautiful neighborhood of Queen ... Belltown The nearest public transit bus (D Line) is 2 b... NaN NaN https://a1.muscache.com/ac/pictures/6120468/b0... NaN 1452570 https://www.airbnb.com/users/show/1452570 Emily 2011-11-29 Seattle, Washington, United States Hi, I live in Seattle, Washington but I'm orig... within an hour 100% NaN f https://a0.muscache.com/ac/users/1452570/profi... https://a0.muscache.com/ac/users/1452570/profi... Queen Anne 2.0 2.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t 14th Ave W, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.632918 -122.372471 t House Entire home/apt 6 2.0 3.0 3.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $450.00 NaN NaN $700.00 $125.00 6 $15.00 1 1125 7 weeks ago t 30 60 90 365 2016-01-04 38 2012-07-10 2015-10-24 92.0 9.0 9.0 10.0 10.0 9.0 9.0 f NaN WASHINGTON f strict f f 1 0.89
5 5956968 https://www.airbnb.com/rooms/5956968 20160104002432 2016-01-04 Private unit in a 1920s mansion We're renting out a small private unit of one ... If you include a bit of your background in you... We're renting out a small private unit of one ... none This part of Queen Anne has wonderful views an... Let me know if you need anything or have sugge... The #1 and #2 bus picks up 2-3 blocks away (di... https://a2.muscache.com/ac/pictures/84791950/f... https://a2.muscache.com/im/pictures/84791950/f... https://a2.muscache.com/ac/pictures/84791950/f... https://a2.muscache.com/ac/pictures/84791950/f... 326758 https://www.airbnb.com/users/show/326758 Andrew 2010-12-25 Seattle, Washington, United States I've been fortunate to have had many life expe... NaN NaN NaN f https://a2.muscache.com/ac/users/326758/profil... https://a2.muscache.com/ac/users/326758/profil... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t West Comstock Street, Seattle, WA 98119, Unite... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.630525 -122.366174 t House Private room 2 1.0 1.0 1.0 Real Bed {"Wireless Internet","Free Parking on Premises... NaN $120.00 $800.00 NaN NaN $40.00 1 $30.00 1 6 2 weeks ago t 0 0 27 302 2016-01-04 17 2015-06-11 2015-09-28 95.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 1 2.45
6 1909058 https://www.airbnb.com/rooms/1909058 20160104002432 2016-01-04 Queen Anne Private Bed and Bath Enjoy a quiet stay in our comfortable 1915 Cra... Enjoy a quiet stay in our comfortable 1915 Cra... Enjoy a quiet stay in our comfortable 1915 Cra... none Close restaurants, coffee shops and grocery st... The room now has a mini frig to keep your favo... The bus goes through the lower Queen Anne neig... https://a2.muscache.com/ac/pictures/26505642/2... https://a2.muscache.com/im/pictures/26505642/2... https://a2.muscache.com/ac/pictures/26505642/2... https://a2.muscache.com/ac/pictures/26505642/2... 2497928 https://www.airbnb.com/users/show/2497928 Gary And Beth 2012-05-30 Seattle, Washington, United States We have lived in the the Queen Anne neighborho... within an hour 100% 100% t https://a0.muscache.com/ac/users/2497928/profi... https://a0.muscache.com/ac/users/2497928/profi... Queen Anne 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t 10th Avenue West, Seattle, WA 98119, United St... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.636605 -122.368519 t House Private room 2 1.0 1.0 1.0 Real Bed {"Wireless Internet","Free Parking on Premises... NaN $80.00 $575.00 NaN $150.00 NaN 1 $10.00 3 14 5 weeks ago t 20 49 71 346 2016-01-04 58 2014-01-27 2015-12-07 99.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 2.46
7 856550 https://www.airbnb.com/rooms/856550 20160104002432 2016-01-04 Tiny Garden cabin on Queen Anne Our tiny cabin is private , very quiet and com... This cabin was built with Airbnb in mind, Que... Our tiny cabin is private , very quiet and com... none We are centrally located between Downtown and ... There are three rentals in our back yard . If ... the "D" line runs out in front of our house . https://a2.muscache.com/ac/pictures/83538305/d... https://a2.muscache.com/im/pictures/83538305/d... https://a2.muscache.com/ac/pictures/83538305/d... https://a2.muscache.com/ac/pictures/83538305/d... 4016632 https://www.airbnb.com/users/show/4016632 Jean-Marc 2012-10-30 Seattle, Washington, United States I am a carpenter at heart , I love music , I p... within an hour 100% 100% t https://a1.muscache.com/ac/users/4016632/profi... https://a1.muscache.com/ac/users/4016632/profi... Queen Anne 5.0 5.0 ['email', 'phone', 'facebook', 'google', 'link... t t West Wheeler Street, Seattle, WA 98119, United... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.640161 -122.375856 t Cabin Private room 2 1.0 1.0 1.0 Real Bed {"Wireless Internet","Pets live on this proper... NaN $60.00 $360.00 NaN $150.00 $25.00 1 $0.00 2 7 yesterday t 22 42 42 100 2016-01-04 173 2013-01-03 2016-01-01 97.0 10.0 10.0 10.0 10.0 9.0 10.0 f NaN WASHINGTON f strict t t 5 4.73
8 4948745 https://www.airbnb.com/rooms/4948745 20160104002432 2016-01-04 Urban Charm || Downtown || Views Nestled in the heart of the city, this space i... Located in the heart of the city, this space i... Nestled in the heart of the city, this space i... none Walking Score: 92 4 blocks from Kerry Park Fam... NaN Bus stop to downtown directly across the stree... https://a0.muscache.com/ac/pictures/85453284/d... https://a0.muscache.com/im/pictures/85453284/d... https://a0.muscache.com/ac/pictures/85453284/d... https://a0.muscache.com/ac/pictures/85453284/d... 2166277 https://www.airbnb.com/users/show/2166277 Aliza 2012-04-18 Seattle, Washington, United States I'm a 35 year old professional from Seattle, W... NaN NaN 100% f https://a1.muscache.com/ac/users/2166277/profi... https://a1.muscache.com/ac/users/2166277/profi... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'linkedin', 're... t t Queen Anne Avenue North, Seattle, WA 98109, Un... Queen Anne West Queen Anne Queen Anne Seattle WA 98109 Seattle Seattle, WA US United States 47.632410 -122.357216 t Apartment Private room 2 1.0 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $90.00 $500.00 $1,700.00 NaN NaN 1 $0.00 3 1125 5 months ago t 6 36 66 341 2016-01-04 8 2015-06-22 2015-08-17 97.0 10.0 9.0 10.0 9.0 10.0 10.0 f NaN WASHINGTON f strict f f 1 1.22
9 2493658 https://www.airbnb.com/rooms/2493658 20160104002432 2016-01-04 Airy + Bright Queen Anne Apartment Beautiful apartment in an extremely safe, quie... What's special about this place? A beautiful r... Beautiful apartment in an extremely safe, quie... none Queen Anne is a wonderful, truly functional vi... What's up with the free pillows? Our home was... Convenient bus stops are just down the block, ... https://a2.muscache.com/ac/pictures/33003258/f... https://a2.muscache.com/im/pictures/33003258/f... https://a2.muscache.com/ac/pictures/33003258/f... https://a2.muscache.com/ac/pictures/33003258/f... 5177328 https://www.airbnb.com/users/show/5177328 Andrea 2013-02-21 Seattle, Washington, United States Living east coast/left coast/overseas. Time i... within an hour 98% 100% t https://a0.muscache.com/ac/users/5177328/profi... https://a0.muscache.com/ac/users/5177328/profi... Queen Anne 6.0 6.0 ['email', 'phone', 'facebook', 'linkedin', 're... t t 7th Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.637492 -122.366889 t Apartment Entire home/apt 4 1.0 1.0 1.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,"Free... NaN $150.00 $1,000.00 $3,000.00 $100.00 $40.00 1 $0.00 2 365 today t 6 19 49 324 2016-01-04 32 2014-04-27 2015-12-20 97.0 10.0 10.0 10.0 10.0 10.0 9.0 f NaN WASHINGTON f strict t t 6 1.55
10 175576 https://www.airbnb.com/rooms/175576 20160104002432 2016-01-04 Private Apartment - Queen Anne Hill Queen Anne Hill is a charming neighborhood wit... Be close to everything! Queen Anne Hill is a ... Queen Anne Hill is a charming neighborhood wit... none Queen Anne Hill is a wonderful and historic ar... We will provide you with a Parking Pass to han... The bus stop is just two blocks from our house... https://a0.muscache.com/ac/pictures/2788698/87... https://a0.muscache.com/im/pictures/2788698/87... https://a0.muscache.com/ac/pictures/2788698/87... https://a0.muscache.com/ac/pictures/2788698/87... 239585 https://www.airbnb.com/users/show/239585 Ray & Eileen 2010-09-19 Seattle, Washington, United States Eileen and Ray were born in Seattle just three... within a few hours 100% 100% t https://a2.muscache.com/ac/users/239585/profil... https://a2.muscache.com/ac/users/239585/profil... Queen Anne 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t 1st Ave W, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.635482 -122.358478 t House Entire home/apt 2 1.0 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $95.00 $595.00 NaN NaN $15.00 2 $15.00 3 7 a week ago t 0 0 0 153 2016-01-04 181 2011-07-21 2015-11-25 97.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate t f 1 3.33
11 4454295 https://www.airbnb.com/rooms/4454295 20160104002432 2016-01-04 Upper Queen Anne Craftsman House Beautifully furnished, cozy 1 bedroom mid cent... Beautiful home in an extremely walkable neighb... Beautifully furnished, cozy 1 bedroom mid cent... none I am located in the Upper Queen Anne neighborh... NaN Yes, bus stops just 2-3 blocks away. https://a0.muscache.com/ac/pictures/59566840/b... https://a0.muscache.com/im/pictures/59566840/b... https://a0.muscache.com/ac/pictures/59566840/b... https://a0.muscache.com/ac/pictures/59566840/b... 4606439 https://www.airbnb.com/users/show/4606439 Nadia 2013-01-06 Seattle, Washington, United States My name is Nadia, and I am a native of Seattle... within a few hours 100% 100% f https://a1.muscache.com/ac/users/4606439/profi... https://a1.muscache.com/ac/users/4606439/profi... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t 3rd Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.637214 -122.360046 t House Entire home/apt 2 1.0 1.0 1.0 Real Bed {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... NaN $99.00 $800.00 $2,000.00 $500.00 $150.00 1 $0.00 3 1125 a week ago t 21 21 21 229 2016-01-04 8 2015-05-06 2015-12-16 97.0 10.0 10.0 9.0 10.0 10.0 9.0 f NaN WASHINGTON f strict f f 1 0.98
12 3883392 https://www.airbnb.com/rooms/3883392 20160104002432 2016-01-04 Open Plan 2bdr/1bath in Queen Anne Spacious apt in popular Seattle neighborhood. ... This apartment is in a quiet and friendly city... Spacious apt in popular Seattle neighborhood. ... none This neighborhood is one of Seattle's popular ... Seattle is a "green" town. Composting and re... #1 bus is one block from the house to downtown... https://a2.muscache.com/ac/pictures/48864586/9... https://a2.muscache.com/im/pictures/48864586/9... https://a2.muscache.com/ac/pictures/48864586/9... https://a2.muscache.com/ac/pictures/48864586/9... 19932967 https://www.airbnb.com/users/show/19932967 Pat & Roberta 2014-08-13 Seattle, Washington, United States We both grew up on Queen Anne Hill, then later... within an hour 100% 100% t https://a1.muscache.com/ac/users/19932967/prof... https://a1.muscache.com/ac/users/19932967/prof... NaN 1.0 1.0 ['email', 'phone', 'linkedin', 'reviews', 'jum... t t West Howe Street, Seattle, WA 98119, United St... NaN West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.635546 -122.373171 t Apartment Entire home/apt 4 1.0 2.0 3.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $245.00 $1,575.00 $5,800.00 $300.00 $95.00 1 $0.00 3 14 2 weeks ago t 30 60 90 362 2016-01-04 13 2014-11-09 2015-10-02 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 0.92
13 8889257 https://www.airbnb.com/rooms/8889257 20160104002432 2016-01-04 Elegance in Historic Queen Anne Enjoy our amazing, updated & modern design cot... Originally built in 1906, our house has a ligh... Enjoy our amazing, updated & modern design cot... none Queen Anne hill became a popular spot for the ... NaN Street parking only. From West Prospect, park ... https://a2.muscache.com/ac/pictures/69b4dfed-9... https://a2.muscache.com/im/pictures/69b4dfed-9... https://a2.muscache.com/ac/pictures/69b4dfed-9... https://a2.muscache.com/ac/pictures/69b4dfed-9... 25899989 https://www.airbnb.com/users/show/25899989 Ellie 2015-01-10 Kirkland, Washington, United States Hi, my name is Ellie. I’m a widow. My husban... within an hour 100% 100% f https://a2.muscache.com/ac/pictures/5eee2738-1... https://a2.muscache.com/ac/pictures/5eee2738-1... Queen Anne 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t West Prospect Street, Seattle, WA 98119, Unite... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.629507 -122.367629 t House Entire home/apt 5 1.0 2.0 3.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $165.00 NaN $5,000.00 $400.00 $85.00 4 $20.00 2 1125 today t 13 40 63 337 2016-01-04 3 2015-12-16 2016-01-02 100.0 10.0 10.0 9.0 9.0 10.0 10.0 f NaN WASHINGTON f strict f f 1 3.00
14 5680462 https://www.airbnb.com/rooms/5680462 20160104002432 2016-01-04 Stunning 6 bd in THE BEST Location! Stunning Designsponge featured 6 bed, 3.75 bat... Gorgeous, LIGHT FILLED, Newly Constructed Mode... Stunning Designsponge featured 6 bed, 3.75 bat... none Queen Anne is THE BEST and most desirable neig... The house is great for large groups or extende... Hwy 99 and the 5 freeway are both easy to get ... https://a2.muscache.com/ac/pictures/91278310/1... https://a2.muscache.com/im/pictures/91278310/1... https://a2.muscache.com/ac/pictures/91278310/1... https://a2.muscache.com/ac/pictures/91278310/1... 22372266 https://www.airbnb.com/users/show/22372266 Sarah 2014-10-10 Seattle, Washington, United States Originally from Southern California, my husban... within an hour 100% 100% f https://a2.muscache.com/ac/users/22372266/prof... https://a2.muscache.com/ac/users/22372266/prof... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t 7th Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.639203 -122.365863 t House Entire home/apt 16 3.5 6.0 15.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $461.00 NaN NaN $1,500.00 $300.00 8 $50.00 3 29 5 days ago t 19 40 65 327 2016-01-04 18 2015-06-15 2015-11-15 98.0 9.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON t strict f f 1 2.65
15 8988178 https://www.airbnb.com/rooms/8988178 20160104002432 2016-01-04 Lovely Queen Anne Cottage, 2 BR This home is full of light, art and comfort. 5... The Space This is a 1000 square foot, two bedr... This home is full of light, art and comfort. 5... none Queen Anne is a charming and very safe neighbo... NaN You will be 2 blocks from the Metro stop. On ... NaN NaN https://a2.muscache.com/ac/pictures/fa176cce-b... NaN 2983711 https://www.airbnb.com/users/show/2983711 Paige 2012-07-18 Seattle, Washington, United States I'm from Seattle. I am a designer, inventor a... within a few hours 100% 100% f https://a0.muscache.com/ac/users/2983711/profi... https://a0.muscache.com/ac/users/2983711/profi... NaN 1.0 1.0 ['email', 'reviews', 'kba'] t f 12th Avenue West, Seattle, WA 98119, United St... NaN West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.635650 -122.372893 f House Entire home/apt 5 1.0 2.0 2.0 Real Bed {TV,"Cable TV",Internet,Kitchen,"Free Parking ... NaN $109.00 NaN NaN NaN $89.00 1 $0.00 3 15 3 days ago t 30 60 69 69 2016-01-04 1 2015-11-25 2015-11-25 80.0 8.0 10.0 8.0 8.0 8.0 8.0 f NaN WASHINGTON f strict f f 1 0.73
16 3245876 https://www.airbnb.com/rooms/3245876 20160104002432 2016-01-04 Park Life in Lower Queen Anne Master bedroom suite with 1/4 bath & kitchenet... **PLEASE MAKE SURE TO READ ALL INFO BEFORE BOO... Master bedroom suite with 1/4 bath & kitchenet... none Lower Queen Anne is amazing - you can walk to ... I have two cats, Tori Spelling and Denzel. The... Taxi: Uber, Sidecar, and Lyft are all availabl... https://a0.muscache.com/ac/pictures/57011178/e... https://a0.muscache.com/im/pictures/57011178/e... https://a0.muscache.com/ac/pictures/57011178/e... https://a0.muscache.com/ac/pictures/57011178/e... 9465817 https://www.airbnb.com/users/show/9465817 Libby 2013-10-16 Seattle, Washington, United States I'm a 37 year old recent law school graduate, ... within an hour 100% 100% f https://a2.muscache.com/ac/users/9465817/profi... https://a2.muscache.com/ac/users/9465817/profi... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'linkedin', 're... t t West Mercer Place, Seattle, WA 98119, United S... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.626200 -122.366602 t Apartment Private room 2 1.0 1.0 1.0 Real Bed {Internet,"Wireless Internet","Pets Allowed",B... NaN $66.00 NaN NaN $100.00 $35.00 1 $25.00 1 10 yesterday t 29 59 89 364 2016-01-04 84 2014-06-30 2016-01-02 95.0 10.0 9.0 10.0 10.0 10.0 9.0 f NaN WASHINGTON f moderate f f 1 4.55
17 4933447 https://www.airbnb.com/rooms/4933447 20160104002432 2016-01-04 Private Garden Suite, Bay View Beautiful private entrance garden suite overlo... French Country style home built in 1939 with s... Beautiful private entrance garden suite overlo... none We are located in Upper Queen Anne in walking ... Electric hot water kettle provided for hot bev... Our central location means quick access to all... https://a1.muscache.com/ac/pictures/65170901/6... https://a1.muscache.com/im/pictures/65170901/6... https://a1.muscache.com/ac/pictures/65170901/6... https://a1.muscache.com/ac/pictures/65170901/6... 25417834 https://www.airbnb.com/users/show/25417834 Markus And Melissa 2014-12-31 Seattle, Washington, United States NaN within an hour 100% 100% t https://a1.muscache.com/ac/users/25417834/prof... https://a1.muscache.com/ac/users/25417834/prof... Queen Anne 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t 12th Avenue West, Seattle, WA 98119, United St... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.640646 -122.372406 t House Private room 2 1.0 1.0 1.0 Real Bed {"Wireless Internet","Free Parking on Premises... NaN $99.00 NaN NaN $100.00 $15.00 1 $0.00 2 14 2 weeks ago t 29 52 82 171 2016-01-04 45 2015-03-16 2015-11-06 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON t moderate f f 1 4.58
18 7735464 https://www.airbnb.com/rooms/7735464 20160104002432 2016-01-04 Queen Anne Getaway Near Seattle! The second room in our spacious 2BR / 2 Bath a... NaN The second room in our spacious 2BR / 2 Bath a... none NaN NaN NaN https://a2.muscache.com/ac/pictures/98338372/c... https://a2.muscache.com/im/pictures/98338372/c... https://a2.muscache.com/ac/pictures/98338372/c... https://a2.muscache.com/ac/pictures/98338372/c... 6170760 https://www.airbnb.com/users/show/6170760 Sam 2013-04-30 Seattle, Washington, United States Sam NaN NaN NaN f https://a2.muscache.com/ac/users/6170760/profi... https://a2.muscache.com/ac/users/6170760/profi... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'jum... t t 11th Avenue West, Seattle, WA 98119, United St... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.639776 -122.372235 t Apartment Private room 2 2.0 1.0 1.0 Futon {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $200.00 NaN NaN NaN NaN 1 $0.00 1 1125 5 months ago t 0 0 0 125 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f flexible f f 1 NaN
19 6291829 https://www.airbnb.com/rooms/6291829 20160104002432 2016-01-04 Grand Craftsman Home on Queen Anne This home built in 1909. It has 5 bedrooms a... This home encompasses the character that is so... This home built in 1909. It has 5 bedrooms a... none Upper Queen Anne is a charming neighborhood wi... This is our family home that we choose to shar... Easy bus access to all the sites: Lower Queen ... NaN NaN https://a1.muscache.com/ac/pictures/78564472/f... NaN 32713558 https://www.airbnb.com/users/show/32713558 Kary 2015-05-05 Seattle, Washington, United States My husband and I have 3 young adult children a... NaN NaN NaN f https://a2.muscache.com/ac/users/32713558/prof... https://a2.muscache.com/ac/users/32713558/prof... Queen Anne 1.0 1.0 ['email', 'phone', 'linkedin', 'reviews', 'kba'] t t 1st Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.636025 -122.358694 t House Entire home/apt 10 3.5 5.0 5.0 Real Bed {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... NaN $700.00 $4,100.00 NaN $500.00 $250.00 1 $0.00 3 30 2 months ago t 24 54 84 359 2016-01-04 5 2015-07-07 2015-08-10 85.0 10.0 9.0 9.0 9.0 8.0 8.0 f NaN WASHINGTON f flexible f f 1 0.82
20 9218403 https://www.airbnb.com/rooms/9218403 20160104002432 2016-01-04 Queen Anne View One Bedroom This clean and comfortable one bedroom sits ri... Kitchen has hot water tap and sodastream Excel... This clean and comfortable one bedroom sits ri... none Lower Queen Anne is near the Seattle Center (s... NaN NaN https://a2.muscache.com/ac/pictures/6374cb3b-a... https://a2.muscache.com/im/pictures/6374cb3b-a... https://a2.muscache.com/ac/pictures/6374cb3b-a... https://a2.muscache.com/ac/pictures/6374cb3b-a... 14100483 https://www.airbnb.com/users/show/14100483 Annie 2014-04-09 Quilcene, Washington, United States NaN within a few hours 100% 100% f https://a0.muscache.com/ac/users/14100483/prof... https://a0.muscache.com/ac/users/14100483/prof... NaN 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t West Olympic Place, Seattle, WA 98119, United ... NaN West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.627940 -122.364959 f Condominium Entire home/apt 1 1.0 1.0 1.0 Real Bed {Internet,"Wireless Internet",Kitchen,"Free Pa... NaN $110.00 $750.00 $2,500.00 NaN NaN 1 $0.00 1 1125 4 weeks ago t 29 55 85 360 2016-01-04 1 2016-01-03 2016-01-03 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f flexible f f 1 1.00
21 4125779 https://www.airbnb.com/rooms/4125779 20160104002432 2016-01-04 Cozy Queen Anne Finished Basement Relax in your own private finished basement sp... Updated daylight basement space with queen and... Relax in your own private finished basement sp... none Just a few minutes walk to many great restaura... Free parking. Queen Anne Farmers Market is on... Metro Transit Bus #13 takes you to downtown Se... https://a1.muscache.com/ac/pictures/52657137/d... https://a1.muscache.com/im/pictures/52657137/d... https://a1.muscache.com/ac/pictures/52657137/d... https://a1.muscache.com/ac/pictures/52657137/d... 21401856 https://www.airbnb.com/users/show/21401856 Nick 2014-09-16 Seattle, Washington, United States I am a father, a devoted husband, a passionate... within an hour 100% 100% f https://a1.muscache.com/ac/users/21401856/prof... https://a1.muscache.com/ac/users/21401856/prof... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews'] t f 2nd Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.636374 -122.361033 t House Private room 3 1.5 1.0 2.0 Real Bed {"Cable TV",Internet,"Wireless Internet","Free... NaN $99.00 $568.00 $2,029.00 NaN $15.00 1 $10.00 1 1125 2 months ago t 30 60 90 365 2016-01-04 11 2014-09-27 2015-10-18 84.0 9.0 9.0 9.0 9.0 10.0 8.0 f NaN WASHINGTON f moderate f f 1 0.71
22 8942678 https://www.airbnb.com/rooms/8942678 20160104002432 2016-01-04 Lovely Queen Anne home Welcome to Seattle! Enjoy your stay in a turn... Centrally located spacious home in the heart o... Welcome to Seattle! Enjoy your stay in a turn... none Queen Anne is a wonderful mix of beautiful tre... NaN The bus stop is 3 blocks away. You are an easy... NaN NaN https://a2.muscache.com/ac/pictures/c7e454ce-7... NaN 46675077 https://www.airbnb.com/users/show/46675077 Susanna 2015-10-16 Seattle, Washington, United States NaN within a day 100% 100% f https://a2.muscache.com/ac/pictures/facd36b6-c... https://a2.muscache.com/ac/pictures/facd36b6-c... Queen Anne 1.0 1.0 ['phone', 'reviews'] t f 1st Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.635632 -122.358881 t House Entire home/apt 8 2.0 4.0 4.0 Real Bed {TV,"Wireless Internet",Kitchen,"Free Parking ... NaN $450.00 $3,000.00 NaN NaN NaN 1 $0.00 4 1125 2 months ago t 0 0 0 53 2016-01-04 1 2015-12-01 2015-12-01 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f flexible f f 1 0.86
23 10106055 https://www.airbnb.com/rooms/10106055 20160104002432 2016-01-04 Cozy Lower Level, Upper Queen Anne Greetings! Our home is a beautiful, 1920's 4 ... The space we are renting is the entire lower l... Greetings! Our home is a beautiful, 1920's 4 ... none Queen Anne is a lovely and venerable Seattle n... NaN Our home is conveniently located within walkin... https://a2.muscache.com/ac/pictures/3f11eb1a-3... https://a2.muscache.com/im/pictures/3f11eb1a-3... https://a2.muscache.com/ac/pictures/3f11eb1a-3... https://a2.muscache.com/ac/pictures/3f11eb1a-3... 51860756 https://www.airbnb.com/users/show/51860756 Maggie & Alex 2015-12-20 Seattle, Washington, United States Hello! We're Maggie & Alex, and we are very ex... NaN NaN NaN f https://a2.muscache.com/ac/pictures/11543d26-5... https://a2.muscache.com/ac/pictures/11543d26-5... Queen Anne 1.0 1.0 ['phone'] t f West Galer Street, Seattle, WA 98119, United S... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.633394 -122.371920 t House Private room 2 1.0 1.0 1.0 Real Bed {Internet,"Wireless Internet","Air Conditionin... NaN $75.00 $350.00 NaN NaN NaN 1 $0.00 1 1125 today t 30 60 90 365 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f flexible f f 1 NaN
24 6362362 https://www.airbnb.com/rooms/6362362 20160104002432 2016-01-04 Charming home on Queen Anne Enjoy Seattle from the ideally located Queen A... Step into the main living space with sitting a... Enjoy Seattle from the ideally located Queen A... none NaN There is plenty of street parking and one desi... 10th Avenue West is on the bus line taking you... NaN NaN https://a1.muscache.com/ac/pictures/79617550/d... NaN 33147763 https://www.airbnb.com/users/show/33147763 Tracy 2015-05-11 Seattle, Washington, United States NaN NaN NaN NaN f https://a1.muscache.com/ac/users/33147763/prof... https://a1.muscache.com/ac/users/33147763/prof... Queen Anne 1.0 1.0 ['email', 'phone', 'reviews'] t f 10th Avenue West, Seattle, WA 98119, United St... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.638517 -122.369581 t House Entire home/apt 5 2.5 3.0 3.0 Real Bed {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... NaN $600.00 NaN NaN $500.00 $150.00 1 $0.00 3 1125 3 months ago t 0 0 0 212 2016-01-04 1 2015-07-20 2015-07-20 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 0.18
25 3544550 https://www.airbnb.com/rooms/3544550 20160104002432 2016-01-04 VIEW-Monthly Rental Available Our home is very light and full of character a... Our home is a brick tudor/cottage built in 193... Our home is very light and full of character a... none Upper Queen Anne is a charming neighborhood fu... Our house is located just 5 short blocks to To... A bus stop is just 2 blocks away. Easy bus a... NaN NaN https://a1.muscache.com/ac/pictures/44791979/6... NaN 16708587 https://www.airbnb.com/users/show/16708587 Jill 2014-06-12 Seattle, Washington, United States i love living in Seattle. i grew up in the mi... within a few hours 67% 100% f https://a1.muscache.com/ac/users/16708587/prof... https://a1.muscache.com/ac/users/16708587/prof... Queen Anne 2.0 2.0 ['email', 'phone', 'google', 'reviews', 'jumio'] t t 7th Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.631397 -122.367767 t House Entire home/apt 8 2.5 3.0 5.0 Real Bed {TV,"Cable TV","Wireless Internet","Air Condit... NaN $450.00 NaN NaN $500.00 $200.00 6 $50.00 4 1125 today t 0 3 33 293 2016-01-04 8 2015-07-04 2015-09-02 100.0 10.0 10.0 9.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 2 1.30
26 9025039 https://www.airbnb.com/rooms/9025039 20160104002432 2016-01-04 Cute Bungalow-Close to Everything! Our cozy little bungalow is the perfect place ... One bedroom has a queen sized bed, and the oth... Our cozy little bungalow is the perfect place ... none The Queen Anne neighborhood is one of the most... The Queen Anne neighborhood is one of the most... There are several bus routes a few short steps... NaN NaN https://a2.muscache.com/ac/pictures/21a1c1e1-f... NaN 68155 https://www.airbnb.com/users/show/68155 Lori 2010-01-06 Seattle, Washington, United States Mom to two young boys, writer, real estate bro... within a few hours 100% 100% f https://a2.muscache.com/ac/users/68155/profile... https://a2.muscache.com/ac/users/68155/profile... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'jum... t t West McGraw Street, Seattle, WA 98119, United ... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.638752 -122.367973 t House Entire home/apt 5 1.0 2.0 3.0 Real Bed {"Cable TV","Wireless Internet",Kitchen,"Free ... NaN $150.00 NaN NaN $250.00 $35.00 1 $0.00 1 1125 3 days ago t 0 0 0 49 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f flexible f f 1 NaN
27 3200646 https://www.airbnb.com/rooms/3200646 20160104002432 2016-01-04 Micro Gypsy Wagon on Queen Anne Micro camper with queen size bed and seating f... The Spruce Kaboose is a hand built one of a ki... Micro camper with queen size bed and seating f... none Interbay is right between downtown Seattle and... There are THREE rentals in our yard . If your ... We are on the D bus line. If you are busing f... https://a0.muscache.com/ac/pictures/67216372/d... https://a0.muscache.com/im/pictures/67216372/d... https://a0.muscache.com/ac/pictures/67216372/d... https://a0.muscache.com/ac/pictures/67216372/d... 4016632 https://www.airbnb.com/users/show/4016632 Jean-Marc 2012-10-30 Seattle, Washington, United States I am a carpenter at heart , I love music , I p... within an hour 100% 100% t https://a1.muscache.com/ac/users/4016632/profi... https://a1.muscache.com/ac/users/4016632/profi... Queen Anne 5.0 5.0 ['email', 'phone', 'facebook', 'google', 'link... t t West Wheeler Street, Seattle, WA 98119, United... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.639266 -122.374726 t Camper/RV Private room 2 1.0 1.0 1.0 Real Bed {"Wireless Internet","Pets live on this proper... NaN $45.00 $360.00 NaN $150.00 $25.00 1 $0.00 2 7 yesterday t 22 49 49 107 2016-01-04 80 2014-07-06 2016-01-02 95.0 10.0 10.0 10.0 10.0 9.0 9.0 f NaN WASHINGTON f strict t t 5 4.38
28 8859380 https://www.airbnb.com/rooms/8859380 20160104002432 2016-01-04 STUNNING VIEW of Puget Sound This three bedroom flat is your gorgeous retre... You won't want to leave your home away from ho... This three bedroom flat is your gorgeous retre... none Located in the beautiful neighborhood of Queen... NaN You have on-site parking if you have a car. If... NaN NaN https://a2.muscache.com/ac/pictures/ed5b5e7c-7... NaN 3792761 https://www.airbnb.com/users/show/3792761 Kimberly 2012-10-07 Seattle, Washington, United States I am from Seattle WA, and I love to travel! \r... within an hour 100% 100% f https://a2.muscache.com/ac/pictures/15d8ced5-c... https://a2.muscache.com/ac/pictures/15d8ced5-c... Queen Anne 5.0 5.0 ['email', 'phone', 'reviews', 'jumio', 'kba'] t t 9th Avenue West, Seattle, WA 98119, United States Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.629907 -122.368948 t Apartment Entire home/apt 6 2.0 3.0 3.0 Real Bed {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... NaN $300.00 NaN NaN $500.00 $125.00 1 $0.00 2 1125 4 days ago t 24 54 84 356 2016-01-04 6 2015-10-24 2016-01-02 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON t moderate f f 1 2.47
29 4520099 https://www.airbnb.com/rooms/4520099 20160104002432 2016-01-04 Open Airy Queen Anne Condo Designer home situated on Queen Anne Hill over... During the summer, there was construction on t... Designer home situated on Queen Anne Hill over... none This is a really quiet neighborhood with plent... My neighbors are really quiet and the condo do... There is a very convenient bus line a block aw... https://a0.muscache.com/ac/pictures/60875300/3... https://a0.muscache.com/im/pictures/60875300/3... https://a0.muscache.com/ac/pictures/60875300/3... https://a0.muscache.com/ac/pictures/60875300/3... 6184895 https://www.airbnb.com/users/show/6184895 Lana 2013-05-01 Seattle, Washington, United States NaN within an hour 71% 100% f https://a1.muscache.com/ac/users/6184895/profi... https://a1.muscache.com/ac/users/6184895/profi... Queen Anne 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t 14th Avenue West, Seattle, WA 98119, United St... Queen Anne West Queen Anne Queen Anne Seattle WA 98119 Seattle Seattle, WA US United States 47.639816 -122.374338 t Apartment Entire home/apt 3 1.0 1.0 2.0 Real Bed {TV,"Cable TV","Wireless Internet","Wheelchair... NaN $80.00 $500.00 NaN NaN $65.00 3 $50.00 2 1125 5 days ago t 0 1 30 305 2016-01-04 4 2015-01-04 2015-07-25 85.0 8.0 9.0 7.0 10.0 9.0 9.0 f NaN WASHINGTON f strict f f 1 0.33
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
3788 7745196 https://www.airbnb.com/rooms/7745196 20160104002432 2016-01-04 Cozy Modern Apartment in Fremont Our apartment is bright and airy and a modern ... Our apartment is brand new construction with t... Our apartment is bright and airy and a modern ... none The Fremont neighborhood of Seattle is known a... We strive to stay competitive on rates while o... It's easy to get around Seattle from our neigh... https://a2.muscache.com/ac/pictures/102889373/... https://a2.muscache.com/im/pictures/102889373/... https://a2.muscache.com/ac/pictures/102889373/... https://a2.muscache.com/ac/pictures/102889373/... 398005 https://www.airbnb.com/users/show/398005 Trevor 2011-02-18 Seattle, Washington, United States I'm from Seattle, WA, where I live with the lo... within an hour 100% 100% f https://a0.muscache.com/ac/users/398005/profil... https://a0.muscache.com/ac/users/398005/profil... Fremont 1.0 1.0 ['email', 'phone', 'google', 'reviews', 'kba'] t t Woodland Park Avenue North, Seattle, WA 98103,... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.656739 -122.344865 t Apartment Entire home/apt 4 1.0 1.0 2.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,Heati... NaN $115.00 $850.00 $3,240.00 $199.00 $60.00 2 $12.00 1 1125 2 weeks ago t 20 46 76 347 2016-01-04 14 2015-09-03 2015-12-20 99.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 1 3.39
3789 4645405 https://www.airbnb.com/rooms/4645405 20160104002432 2016-01-04 Private light, minimalist room The extremely comfortable sleep number Califor... Vintage, modern 1910 craftsman with dark expos... The extremely comfortable sleep number Califor... none I love that I can walk 15 minutes into Fremont... Check in: 6pm Check out: 10am There is a lock... Walk Score :Very Walkable Transit Score: Good ... https://a2.muscache.com/ac/pictures/109434352/... https://a2.muscache.com/im/pictures/109434352/... https://a2.muscache.com/ac/pictures/109434352/... https://a2.muscache.com/ac/pictures/109434352/... 13771267 https://www.airbnb.com/users/show/13771267 Paige 2014-04-01 Seattle, Washington, United States I am a freelance photographer born and raised ... within a few hours 100% 100% f https://a1.muscache.com/ac/users/13771267/prof... https://a1.muscache.com/ac/users/13771267/prof... Fremont 2.0 2.0 ['email', 'phone', 'reviews', 'kba'] t t North 46th Street, Seattle, WA 98103, United S... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.661171 -122.349923 t House Private room 2 1.0 1.0 1.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,Heati... NaN $60.00 $500.00 $1,500.00 NaN $10.00 2 $25.00 1 14 today t 28 54 84 359 2016-01-04 23 2015-02-17 2015-11-28 90.0 9.0 9.0 9.0 10.0 9.0 9.0 f NaN WASHINGTON f flexible f f 2 2.14
3790 2755730 https://www.airbnb.com/rooms/2755730 20160104002432 2016-01-04 Your own 2 Bedroom home in Fremont Private 2 bedroom retreat in the heart of Frem... The house was built in 1906 by the Seattle Lum... Private 2 bedroom retreat in the heart of Frem... none Very walkable, with lots of bike lanes and qui... NaN Metro transit lines are one block away with di... https://a1.muscache.com/ac/pictures/40919375/2... https://a1.muscache.com/im/pictures/40919375/2... https://a1.muscache.com/ac/pictures/40919375/2... https://a1.muscache.com/ac/pictures/40919375/2... 3752499 https://www.airbnb.com/users/show/3752499 Donna 2012-10-04 Seattle, Washington, United States I am so proud to have converted the first floo... within an hour 100% 100% t https://a2.muscache.com/ac/users/3752499/profi... https://a2.muscache.com/ac/users/3752499/profi... Fremont 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t North 35th Street, Seattle, WA 98103, United S... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.649271 -122.347817 t Apartment Entire home/apt 6 1.0 2.0 3.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,"Pets... NaN $175.00 NaN NaN $250.00 $50.00 4 $30.00 2 29 today t 18 48 78 335 2016-01-04 75 2014-05-18 2015-12-14 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON t strict f f 1 3.77
3791 7949448 https://www.airbnb.com/rooms/7949448 20160104002432 2016-01-04 Private Suite in Fremont-Ballard This is a private suite with bedroom and bathr... This is a ground floor bedroom in our townhous... This is a private suite with bedroom and bathr... none Our house is centrally located between Ballard... Parking There is adequate free parking on the ... BUS LINES The house is close to bus lines tha... https://a1.muscache.com/ac/pictures/101354275/... https://a1.muscache.com/im/pictures/101354275/... https://a1.muscache.com/ac/pictures/101354275/... https://a1.muscache.com/ac/pictures/101354275/... 26392625 https://www.airbnb.com/users/show/26392625 Jason 2015-01-20 Seattle, Washington, United States My name is Jason and my wife is Keri. We have... within a few hours 100% 100% f https://a0.muscache.com/ac/users/26392625/prof... https://a0.muscache.com/ac/users/26392625/prof... Fremont 1.0 1.0 ['email', 'phone', 'linkedin', 'reviews', 'kba'] t t 6th Avenue Northwest, Seattle, WA 98107, Unite... Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.659149 -122.363466 t House Private room 2 1.0 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","F... NaN $85.00 $600.00 $2,250.00 $100.00 $40.00 1 $0.00 2 30 4 days ago t 29 59 89 178 2016-01-04 11 2015-08-25 2015-11-28 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 2.48
3792 9288840 https://www.airbnb.com/rooms/9288840 20160104002432 2016-01-04 City Haven Vacationing in Seattle? Traveling for business... NaN Vacationing in Seattle? Traveling for business... none NaN NaN NaN https://a2.muscache.com/ac/pictures/40835954-c... https://a2.muscache.com/im/pictures/40835954-c... https://a2.muscache.com/ac/pictures/40835954-c... https://a2.muscache.com/ac/pictures/40835954-c... 15784748 https://www.airbnb.com/users/show/15784748 Teresa 2014-05-20 Seattle, Washington, United States NaN within an hour 100% NaN f https://a2.muscache.com/ac/pictures/34a8914a-2... https://a2.muscache.com/ac/pictures/34a8914a-2... Fremont 1.0 1.0 ['email', 'phone', 'kba'] t f North 46th Street, Seattle, WA 98103, United S... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.663040 -122.348499 t Apartment Entire home/apt 4 1.0 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $109.00 NaN NaN $200.00 $45.00 1 $0.00 2 1125 5 days ago t 0 0 0 34 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f flexible f f 1 NaN
3793 3312406 https://www.airbnb.com/rooms/3312406 20160104002432 2016-01-04 Seattle Urban-Chic Studio Cottage Come stay at this 2014 Northwest Green Home To... Private, just-built, high-end studio loft in a... Come stay at this 2014 Northwest Green Home To... none Renowned restaurants, coffeshops and bars, the... We occasionally have friends over for evening ... Super convenient to EVERYTHING and all the bes... NaN NaN https://a1.muscache.com/ac/pictures/54326594/8... NaN 16727906 https://www.airbnb.com/users/show/16727906 Tory 2014-06-13 Seattle, Washington, United States My husband, Adam, and I, live in the main hous... within an hour 100% 100% t https://a0.muscache.com/ac/users/16727906/prof... https://a0.muscache.com/ac/users/16727906/prof... Fremont 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t Baker Avenue Northwest, Seattle, WA 98107, Uni... Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.660056 -122.357683 t House Entire home/apt 4 1.0 0.0 2.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $109.00 $725.00 $2,895.00 $200.00 $55.00 4 $30.00 2 180 today t 17 44 66 341 2016-01-04 78 2014-07-07 2015-12-30 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON t strict f f 1 4.28
3794 6621924 https://www.airbnb.com/rooms/6621924 20160104002432 2016-01-04 Hazel Heights Hideout An one-bedroom apartment in the top level of m... Enter via the big back deck which has views of... An one-bedroom apartment in the top level of m... none Fremont - The Center Of The Universe. This ne... My neighborhood is a residential neighborhood,... Walking distance to Fremont, which has tons of... https://a1.muscache.com/ac/pictures/85686578/1... https://a1.muscache.com/im/pictures/85686578/1... https://a1.muscache.com/ac/pictures/85686578/1... https://a1.muscache.com/ac/pictures/85686578/1... 30049045 https://www.airbnb.com/users/show/30049045 Tim And Amanda 2015-03-26 Seattle, Washington, United States Passionate travelers and hosts! We hope you do... within a few hours 80% 100% f https://a2.muscache.com/ac/users/30049045/prof... https://a2.muscache.com/ac/users/30049045/prof... Fremont 1.0 1.0 ['email', 'phone', 'reviews', 'jumio'] t t Northwest Bowdoin Place, Seattle, WA 98107, Un... Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.654199 -122.359987 t Apartment Entire home/apt 2 1.0 1.0 1.0 Real Bed {"Wireless Internet",Kitchen,Heating,"Smoke De... NaN $107.00 $1,000.00 $3,633.00 NaN $40.00 2 $30.00 2 1125 2 months ago t 30 60 89 89 2016-01-04 21 2015-06-16 2015-12-15 90.0 9.0 9.0 10.0 10.0 9.0 8.0 f NaN WASHINGTON f flexible f f 1 3.10
3795 5673552 https://www.airbnb.com/rooms/5673552 20160104002432 2016-01-04 Beautiful loft in downtown Fremont Our cool loft apartment offers a convenient lo... This historic building houses a converted stor... Our cool loft apartment offers a convenient lo... none Fremont is a unique, young neighborhood filled... Since the apartment is right on the streets of... Easily accessible from the SeaTac Airport by b... https://a2.muscache.com/ac/pictures/73308107/f... https://a2.muscache.com/im/pictures/73308107/f... https://a2.muscache.com/ac/pictures/73308107/f... https://a2.muscache.com/ac/pictures/73308107/f... 28007250 https://www.airbnb.com/users/show/28007250 Brittney 2015-02-19 Seattle, Washington, United States Working for Brooks Sports, love living in Seat... within an hour 100% 100% t https://a1.muscache.com/ac/users/28007250/prof... https://a1.muscache.com/ac/users/28007250/prof... NaN 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'jum... t t Woodland Park Ave N, Seattle, WA 98103, United... NaN Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.650124 -122.343283 f Loft Entire home/apt 4 1.0 0.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $200.00 NaN NaN NaN $40.00 1 $0.00 2 1125 3 months ago t 2 2 2 265 2016-01-04 10 2015-04-26 2015-10-24 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f flexible f f 1 1.18
3796 609701 https://www.airbnb.com/rooms/609701 20160104002432 2016-01-04 Charming Fremont Garden Cottage Enjoy the excitement of Seattle and city life ... Charming and pristine pied-a-terre in the mids... Enjoy the excitement of Seattle and city life ... none FREMONT is such a fun neighborhood with lot's ... Street parking is usually plentiful so help yo... NaN https://a2.muscache.com/ac/pictures/8157091/5a... https://a2.muscache.com/im/pictures/8157091/5a... https://a2.muscache.com/ac/pictures/8157091/5a... https://a2.muscache.com/ac/pictures/8157091/5a... 3023407 https://www.airbnb.com/users/show/3023407 Nan 2012-07-23 Seattle, Washington, United States I'm a native Northwesterner and love to travel... within an hour 100% 100% t https://a0.muscache.com/ac/users/3023407/profi... https://a0.muscache.com/ac/users/3023407/profi... Fremont 1.0 1.0 ['email', 'phone', 'reviews', 'jumio'] t t NW 40th St, Seattle, WA 98107, United States Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.656508 -122.360571 t Cabin Entire home/apt 2 1.0 1.0 1.0 Real Bed {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... NaN $85.00 NaN NaN NaN $20.00 1 $0.00 2 30 yesterday t 25 48 75 307 2016-01-04 233 2012-07-29 2015-12-31 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON t moderate f f 1 5.57
3797 10118341 https://www.airbnb.com/rooms/10118341 20160104002432 2016-01-04 Fremont Lighthouse Mother-in-Law A clean and simple mother-in-law across the st... A clean and simple mother-in-law basement stud... A clean and simple mother-in-law across the st... none Located at the top of Fremont neighborhood/up ... NaN NaN https://a2.muscache.com/ac/pictures/8cf79670-c... https://a2.muscache.com/im/pictures/8cf79670-c... https://a2.muscache.com/ac/pictures/8cf79670-c... https://a2.muscache.com/ac/pictures/8cf79670-c... 1237248 https://www.airbnb.com/users/show/1237248 Elise 2011-10-02 Seattle, Washington, United States Technology Marketing professional, likes outdo... within an hour 100% 100% f https://a0.muscache.com/ac/users/1237248/profi... https://a0.muscache.com/ac/users/1237248/profi... Fremont 1.0 1.0 ['email', 'phone', 'linkedin', 'reviews', 'kba'] t t Phinney Avenue North, Seattle, WA 98103, Unite... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.658976 -122.354915 t House Entire home/apt 2 1.0 0.0 1.0 Futon {"Wireless Internet",Kitchen,Heating,Washer,Dr... NaN $70.00 NaN NaN $200.00 NaN 2 $20.00 3 1125 yesterday t 2 2 2 2 2016-01-04 1 2016-01-02 2016-01-02 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 1 1.00
3798 2614387 https://www.airbnb.com/rooms/2614387 20160104002432 2016-01-04 Everything Seattle in 0-3 miles, A Spacious 1 bedroom: private 3/4 bathroom, Quee... New, modern, clean, quiet and no clutter, yet ... Spacious 1 bedroom: private 3/4 bathroom, Quee... none I love everything about my neighborhood, Seatt... A few blocks from the house is Manolin Seafood... Free on-street parking. Easy public transit. B... https://a0.muscache.com/ac/pictures/63200945/a... https://a0.muscache.com/im/pictures/63200945/a... https://a0.muscache.com/ac/pictures/63200945/a... https://a0.muscache.com/ac/pictures/63200945/a... 1123549 https://www.airbnb.com/users/show/1123549 Sandy 2011-09-07 Seattle, Washington, United States Hello,\r\nI like the airbnb concept because I ... within an hour 100% 100% f https://a0.muscache.com/ac/users/1123549/profi... https://a0.muscache.com/ac/users/1123549/profi... Fremont 2.0 2.0 ['email', 'phone', 'reviews', 'kba'] t t Midvale Avenue North, Seattle, WA 98103, Unite... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.655381 -122.343205 t House Private room 2 1.0 1.0 1.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,"Free... NaN $77.00 $499.00 NaN NaN $15.00 2 $15.00 2 14 a week ago t 19 42 72 338 2016-01-04 128 2014-03-31 2015-12-31 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 2 5.95
3799 7735100 https://www.airbnb.com/rooms/7735100 20160104002432 2016-01-04 Master bedroom in Fremont The townhouse is conveniently blocks away from... NaN The townhouse is conveniently blocks away from... none NaN NaN NaN NaN NaN https://a1.muscache.com/ac/pictures/98338478/f... NaN 7227474 https://www.airbnb.com/users/show/7227474 Roger 2013-07-01 Seattle, Washington, United States Hi! I've spent my whole life on the west coast... a few days or more 25% 100% f https://a0.muscache.com/ac/users/7227474/profi... https://a0.muscache.com/ac/users/7227474/profi... Fremont 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t Dayton Avenue North, Seattle, WA 98103, United... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.652902 -122.352110 t Townhouse Private room 2 1.0 1.0 1.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,"Free... NaN $65.00 $375.00 $1,400.00 $150.00 $25.00 1 $0.00 2 1125 2 weeks ago t 6 6 6 269 2016-01-04 5 2015-08-16 2015-12-25 95.0 10.0 9.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 1.06
3800 5482204 https://www.airbnb.com/rooms/5482204 20160104002432 2016-01-04 Six room suite Seattle's most elegant and romantic lit... Each suite is 900 square feet of luxury and el... Seattle's most elegant and romantic lit... none Chelsea Station Inn is walking distance to the... Each suite's kitchen is coffee ready with Nesp... Super easy by bus or driving ! https://a1.muscache.com/ac/pictures/69724382/f... https://a1.muscache.com/im/pictures/69724382/f... https://a1.muscache.com/ac/pictures/69724382/f... https://a1.muscache.com/ac/pictures/69724382/f... 28432113 https://www.airbnb.com/users/show/28432113 Chelsea Station Inn 2015-02-27 Seattle, Washington, United States Seattle's most elegant and romantic little Inn... NaN NaN NaN f https://a2.muscache.com/ac/users/28432113/prof... https://a2.muscache.com/ac/users/28432113/prof... Fremont 1.0 1.0 ['email', 'phone'] t f Linden Avenue North, Seattle, WA 98103, United... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.663613 -122.349519 t Bed & Breakfast Private room 2 1.5 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $185.00 NaN NaN NaN NaN 1 $0.00 1 1125 10 months ago t 0 0 0 275 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f strict f f 1 NaN
3801 4524575 https://www.airbnb.com/rooms/4524575 20160104002432 2016-01-04 Comfortable Fremont Apartment This lovely apartment is located on the lower ... Our recently renovated apartment is perfect fo... This lovely apartment is located on the lower ... none Fremont is centrally located within the city a... NaN 4 blocks to the #5 bus stop, providing a >20 m... https://a1.muscache.com/ac/pictures/56811707/6... https://a1.muscache.com/im/pictures/56811707/6... https://a1.muscache.com/ac/pictures/56811707/6... https://a1.muscache.com/ac/pictures/56811707/6... 20853099 https://www.airbnb.com/users/show/20853099 Flora 2014-09-02 Seattle, Washington, United States I love family, community, people, culture, art... within a few hours 100% 100% t https://a1.muscache.com/ac/users/20853099/prof... https://a1.muscache.com/ac/users/20853099/prof... Fremont 1.0 1.0 ['email', 'phone', 'linkedin', 'reviews', 'kba'] t t 1st Avenue Northwest, Seattle, WA 98107, Unite... Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.657078 -122.358795 t Apartment Entire home/apt 2 1.0 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $108.00 $700.00 $2,500.00 $200.00 $45.00 2 $10.00 4 1125 a week ago t 30 56 85 85 2016-01-04 28 2014-11-21 2015-12-10 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 2.05
3802 8562314 https://www.airbnb.com/rooms/8562314 20160104002432 2016-01-04 Cozy Craftsman in Heart of Fremont Our rare for its location, 2 bedroom and 1 bat... In a land ruled by condos, it's hard to find a... Our rare for its location, 2 bedroom and 1 bat... none I loved living here before we had 3 kids. The ... Please no parties or large groups at our home.... There is a bus stop on the corner of the stree... https://a0.muscache.com/ac/pictures/108784666/... https://a0.muscache.com/im/pictures/108784666/... https://a0.muscache.com/ac/pictures/108784666/... https://a0.muscache.com/ac/pictures/108784666/... 18774473 https://www.airbnb.com/users/show/18774473 Victoria 2014-07-23 US NaN NaN NaN NaN f https://a2.muscache.com/ac/pictures/9de2d88b-0... https://a2.muscache.com/ac/pictures/9de2d88b-0... NaN 1.0 1.0 ['email', 'phone'] t f North 35th Street, Seattle, WA 98103, United S... NaN Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.650765 -122.347787 f House Entire home/apt 4 1.0 2.0 2.0 Real Bed {TV,"Wireless Internet",Kitchen,"Pets Allowed"... NaN $200.00 $1,300.00 $5,400.00 NaN NaN 1 $0.00 2 1125 3 months ago t 0 0 0 247 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f flexible f f 1 NaN
3803 9698202 https://www.airbnb.com/rooms/9698202 20160104002432 2016-01-04 Clean City House, Lots of Beds Get anywhere in Seattle quickly from this grea... The space is well suited for large groups and ... Get anywhere in Seattle quickly from this grea... none This house is central to any neighborhood you'... NaN Bus lines galore! If you want to use public tr... https://a2.muscache.com/ac/pictures/60f3d68d-f... https://a2.muscache.com/im/pictures/60f3d68d-f... https://a2.muscache.com/ac/pictures/60f3d68d-f... https://a2.muscache.com/ac/pictures/60f3d68d-f... 5325329 https://www.airbnb.com/users/show/5325329 Blair 2013-03-04 Seattle, Washington, United States My name is Blair and I'm glad you are interest... within a few hours 97% 100% f https://a0.muscache.com/ac/users/5325329/profi... https://a0.muscache.com/ac/users/5325329/profi... Queen Anne 9.0 9.0 ['email', 'phone', 'facebook', 'linkedin', 're... t t Linden Avenue North, Seattle, WA 98103, United... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.661131 -122.349238 t House Entire home/apt 16 3.5 4.0 10.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,"Free... NaN $250.00 NaN NaN $250.00 $100.00 12 $25.00 1 1125 today t 25 51 72 328 2016-01-04 4 2015-12-14 2016-01-01 95.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 8 4.00
3804 7178490 https://www.airbnb.com/rooms/7178490 20160104002432 2016-01-04 Cedar House Studio Suite in Fremont Comfortable and clean, this lower level suite ... A lush, private garden path leads to the entra... Comfortable and clean, this lower level suite ... none Upper Fremont is a vibrant neighborhood that o... There is a second staircase that leads to our ... This apartment is centrally located amongst th... https://a2.muscache.com/ac/pictures/91338809/e... https://a2.muscache.com/im/pictures/91338809/e... https://a2.muscache.com/ac/pictures/91338809/e... https://a2.muscache.com/ac/pictures/91338809/e... 566102 https://www.airbnb.com/users/show/566102 Eve 2011-05-07 Seattle, Washington, United States Seattle, WA within a few hours 100% 100% t https://a1.muscache.com/ac/users/566102/profil... https://a1.muscache.com/ac/users/566102/profil... Fremont 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t N 44th st, Seattle, WA 98103, United States Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.660856 -122.352401 t Apartment Entire home/apt 2 1.0 0.0 1.0 Real Bed {TV,Internet,"Wireless Internet",Kitchen,Heati... NaN $125.00 $888.00 NaN $150.00 $45.00 1 $0.00 2 1125 3 weeks ago t 23 53 83 358 2016-01-04 12 2015-08-04 2015-11-29 95.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 1 2.34
3805 8054902 https://www.airbnb.com/rooms/8054902 20160104002432 2016-01-04 2 BR/1 BA Fremont Apt w/ parking This 2 bedroom, 1 bath garden-level apartment ... The Space This 2 bedroom, 1 bath garden-level ... This 2 bedroom, 1 bath garden-level apartment ... none One of the most fun neighborhoods in Seattle. ... This apartment is located directly below our 1... Fremont is a great location for visitors looki... https://a1.muscache.com/ac/pictures/110078306/... https://a1.muscache.com/im/pictures/110078306/... https://a1.muscache.com/ac/pictures/110078306/... https://a1.muscache.com/ac/pictures/110078306/... 4071088 https://www.airbnb.com/users/show/4071088 David 2012-11-05 Seattle, Washington, United States Hi! My name is David and I currently live in ... within an hour 100% 100% f https://a0.muscache.com/ac/users/4071088/profi... https://a0.muscache.com/ac/users/4071088/profi... Fremont 1.0 1.0 ['email', 'phone', 'facebook', 'linkedin', 're... t t 1st Avenue Northwest, Seattle, WA 98107, Unite... Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.653158 -122.356285 t Apartment Entire home/apt 6 1.0 2.0 2.0 Real Bed {TV,Internet,"Wireless Internet","Air Conditio... NaN $100.00 NaN NaN $200.00 $89.00 4 $20.00 2 30 today t 19 49 79 329 2016-01-04 10 2015-10-21 2015-12-23 98.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f strict f f 1 3.95
3806 5458027 https://www.airbnb.com/rooms/5458027 20160104002432 2016-01-04 Sunny Charm in Urban Cottage 2BD Charming urban home with rustic cottage feel. ... NaN Charming urban home with rustic cottage feel. ... none NaN Deb, the cleaning lady & caretaker, will be in... NaN NaN NaN https://a2.muscache.com/ac/pictures/101952566/... NaN 6963318 https://www.airbnb.com/users/show/6963318 Grace 2013-06-17 Seattle, Washington, United States Welcome to Fremont!\n\nI look forward to hosti... within an hour 100% 100% t https://a2.muscache.com/ac/users/6963318/profi... https://a2.muscache.com/ac/users/6963318/profi... Fremont 2.0 2.0 ['email', 'phone', 'reviews', 'jumio'] t t Greenwood Avenue North, Seattle, WA 98103, Uni... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.656057 -122.354514 t House Entire home/apt 4 1.0 2.0 2.0 Real Bed {Internet,"Wireless Internet",Kitchen,Heating,... NaN $160.00 NaN NaN NaN $50.00 1 $0.00 1 1125 3 months ago t 0 0 0 109 2016-01-04 1 2015-08-31 2015-08-31 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f flexible f f 2 0.24
3807 4940491 https://www.airbnb.com/rooms/4940491 20160104002432 2016-01-04 Roof Deck in Fremont/Wallingford Adorable private studio nestled in one of Seat... The studio is filled with beautiful original a... Adorable private studio nestled in one of Seat... none From the apartment it is an easy walk to the h... NaN Public Bus stops right outside the building. NaN NaN https://a2.muscache.com/ac/pictures/63461830/1... NaN 466499 https://www.airbnb.com/users/show/466499 Elizabeth 2011-03-27 Arlington, Massachusetts, United States Until last year, I lived in the Boston area, b... within a day 100% 100% f https://a0.muscache.com/ac/users/466499/profil... https://a0.muscache.com/ac/users/466499/profil... Wallingford 1.0 1.0 ['email', 'phone', 'reviews'] t f Stone Way North, Seattle, WA 98103, United States Wallingford Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.654304 -122.342720 t Apartment Entire home/apt 2 1.0 0.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $109.00 NaN $1,800.00 NaN $25.00 2 $0.00 1 360 4 days ago t 4 21 51 325 2016-01-04 7 2015-04-12 2015-10-04 97.0 10.0 10.0 10.0 10.0 10.0 9.0 f NaN WASHINGTON f strict f f 1 0.78
3808 1844791 https://www.airbnb.com/rooms/1844791 20160104002432 2016-01-04 Beautiful Craftsman - Fremont 3 Bed Our charming home in fabulous Upper Fremont is... This is a classically beautiful Craftsman home... Our charming home in fabulous Upper Fremont is... none Fremont is wonderful; you will love it here. T... Normal check-in time is 3-4:00; whenever possi... The #5 bus is 2 blocks away and it is a 15-20 ... https://a0.muscache.com/ac/pictures/26113769/f... https://a0.muscache.com/im/pictures/26113769/f... https://a0.muscache.com/ac/pictures/26113769/f... https://a0.muscache.com/ac/pictures/26113769/f... 7964921 https://www.airbnb.com/users/show/7964921 Charlie & Sarah 2013-08-05 Seattle, Washington, United States Thank you for considering our house for your a... within a few hours 100% 100% f https://a1.muscache.com/ac/users/7964921/profi... https://a1.muscache.com/ac/users/7964921/profi... Fremont 2.0 2.0 ['email', 'phone', 'reviews', 'kba'] t t Dayton Avenue North, Seattle, WA 98103, United... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.662036 -122.350485 t House Entire home/apt 6 2.0 3.0 3.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $175.00 NaN NaN $500.00 $95.00 4 $30.00 3 1125 today t 19 19 19 294 2016-01-04 29 2013-12-10 2015-10-04 96.0 10.0 9.0 10.0 10.0 10.0 9.0 f NaN WASHINGTON f strict f f 2 1.15
3809 6120046 https://www.airbnb.com/rooms/6120046 20160104002432 2016-01-04 Lake Veiw Cottage in Fremont From the deck of this quaint little apartment ... This one bedroom apartment (Hippy Shack) is de... From the deck of this quaint little apartment ... none This cottage apartment is located just a few b... 1. Is the property quite private? ie. can we s... This cottage apartment is located just a few b... https://a2.muscache.com/ac/pictures/76273783/b... https://a2.muscache.com/im/pictures/76273783/b... https://a2.muscache.com/ac/pictures/76273783/b... https://a2.muscache.com/ac/pictures/76273783/b... 31752892 https://www.airbnb.com/users/show/31752892 Megan 2015-04-22 Seattle, Washington, United States NaN within a day 100% 100% f https://a2.muscache.com/ac/users/31752892/prof... https://a2.muscache.com/ac/users/31752892/prof... Fremont 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t Albion Place North, Seattle, WA 98103, United ... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.648689 -122.343915 t Apartment Entire home/apt 4 1.0 1.0 1.0 Real Bed {"Wheelchair Accessible",Kitchen,Heating,"Fami... NaN $120.00 $600.00 $2,200.00 NaN $75.00 2 $0.00 4 30 5 months ago t 30 60 90 365 2016-01-04 10 2015-04-26 2015-08-30 80.0 8.0 7.0 9.0 9.0 9.0 8.0 f NaN WASHINGTON f strict f f 1 1.18
3810 262764 https://www.airbnb.com/rooms/262764 20160104002432 2016-01-04 Fremont Farmhouse Our 2BR/1 bath home in Fremont's most fun neig... 1200 ft2 2BR, 1 Bath farmhouse with a large, t... Our 2BR/1 bath home in Fremont's most fun neig... none We love that Fremont is so centrally located t... We have two cats, Polly and Theo. They are ind... We're centrally located to several bus stops t... https://a1.muscache.com/ac/pictures/75088108/6... https://a1.muscache.com/im/pictures/75088108/6... https://a1.muscache.com/ac/pictures/75088108/6... https://a1.muscache.com/ac/pictures/75088108/6... 1379138 https://www.airbnb.com/users/show/1379138 Rachel 2011-11-07 Seattle, Washington, United States We are a professional family with 2 high energ... within an hour 100% 100% f https://a0.muscache.com/ac/users/1379138/profi... https://a0.muscache.com/ac/users/1379138/profi... Fremont 1.0 1.0 ['email', 'phone', 'linkedin', 'reviews', 'kba'] t t N Bowdoin Pl, Seattle, WA 98103, United States Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.654205 -122.352604 t House Entire home/apt 5 1.0 2.0 3.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... 1200.0 $154.00 $1,120.00 $5,500.00 $150.00 $85.00 4 $50.00 2 14 4 days ago t 13 43 73 227 2016-01-04 5 2015-10-01 2015-12-27 92.0 9.0 8.0 10.0 10.0 10.0 8.0 f NaN WASHINGTON f strict f f 1 1.56
3811 8578490 https://www.airbnb.com/rooms/8578490 20160104002432 2016-01-04 Super Convenient Top Floor Apt In the true spirit of AirBNB this unit is avai... The building is older (1970's) so not the mode... In the true spirit of AirBNB this unit is avai... none I am equidistant to Fremont and Wallingford an... Laundry is available but is $1.75 to wash and ... How to Get to: UW/Husky Stadium): 10 minute d... https://a2.muscache.com/ac/pictures/109014114/... https://a2.muscache.com/im/pictures/109014114/... https://a2.muscache.com/ac/pictures/109014114/... https://a2.muscache.com/ac/pictures/109014114/... 11847918 https://www.airbnb.com/users/show/11847918 Ryan 2014-02-01 Seattle, Washington, United States NaN within a few hours 100% 100% f https://a1.muscache.com/ac/users/11847918/prof... https://a1.muscache.com/ac/users/11847918/prof... Fremont 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t Whitman Avenue North, Seattle, WA 98103, Unite... Fremont Fremont Other neighborhoods Seattle WA 98103 Seattle Seattle, WA US United States 47.657898 -122.346692 t Apartment Entire home/apt 3 1.0 1.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $65.00 NaN NaN NaN $20.00 1 $0.00 1 1125 a week ago t 2 10 13 221 2016-01-04 2 2015-10-01 2015-10-16 100.0 9.0 8.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 0.63
3812 3383329 https://www.airbnb.com/rooms/3383329 20160104002432 2016-01-04 OF THE TREE & CLOUDS. KID FRIENDLY! Of the Tree & Clouds' "Roots" apartment is 8 b... The 1-bedroom, ground-floor Roots apartment is... Of the Tree & Clouds' "Roots" apartment is 8 b... none It's taken me a while to figure out why Fremon... There is NO television. We do have good WI-FI.... The apartment is easily accessed from I-5 Nort... https://a0.muscache.com/ac/pictures/108686685/... https://a0.muscache.com/im/pictures/108686685/... https://a0.muscache.com/ac/pictures/108686685/... https://a0.muscache.com/ac/pictures/108686685/... 3443346 https://www.airbnb.com/users/show/3443346 Jacqueline 2012-09-01 Seattle, Washington, United States I’ve been a landlord (and loved it) for fourte... within an hour 100% 100% t https://a0.muscache.com/ac/users/3443346/profi... https://a0.muscache.com/ac/users/3443346/profi... Fremont 3.0 3.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t Northwest 39th Street, Seattle, WA 98107, Unit... Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.654516 -122.358124 t Apartment Entire home/apt 4 1.0 1.0 2.0 Real Bed {Internet,"Wireless Internet",Kitchen,"Free Pa... NaN $95.00 $600.00 $2,200.00 $500.00 NaN 2 $8.00 3 365 yesterday t 11 30 43 287 2016-01-04 73 2014-07-08 2015-12-29 96.0 10.0 10.0 10.0 10.0 9.0 10.0 f NaN WASHINGTON t moderate t t 3 4.01
3813 8101950 https://www.airbnb.com/rooms/8101950 20160104002432 2016-01-04 3BR Mountain View House in Seattle Our 3BR/2BA house boasts incredible views of t... Our 3BR/2BA house bright, stylish, and wheelch... Our 3BR/2BA house boasts incredible views of t... none We're located near lots of family fun. Woodlan... NaN NaN https://a2.muscache.com/ac/pictures/103217071/... https://a2.muscache.com/im/pictures/103217071/... https://a2.muscache.com/ac/pictures/103217071/... https://a2.muscache.com/ac/pictures/103217071/... 31148752 https://www.airbnb.com/users/show/31148752 Bo 2015-04-13 US NaN within a few hours 99% 100% f https://a2.muscache.com/ac/users/31148752/prof... https://a2.muscache.com/ac/users/31148752/prof... Holly 354.0 354.0 ['email', 'phone', 'linkedin', 'reviews', 'jum... t t Northwest 48th Street, Seattle, WA 98107, Unit... Fremont Fremont Other neighborhoods Seattle WA 98107 Seattle Seattle, WA US United States 47.664295 -122.359170 t House Entire home/apt 6 2.0 3.0 3.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet","A... NaN $359.00 NaN NaN NaN $230.00 1 $0.00 3 1125 today t 18 32 32 32 2016-01-04 1 2015-09-27 2015-09-27 80.0 8.0 10.0 4.0 8.0 10.0 8.0 f NaN WASHINGTON f strict f f 8 0.30
3814 8902327 https://www.airbnb.com/rooms/8902327 20160104002432 2016-01-04 Portage Bay View!-One Bedroom Apt 800 square foot 1 bedroom basement apartment w... This space has a great view of Portage Bay wit... 800 square foot 1 bedroom basement apartment w... none The neighborhood is a quiet oasis that is clos... This is a basement apartment in a newer reside... Uber and Car2go are good options in Seattle. T... https://a2.muscache.com/ac/pictures/626d4b1f-6... https://a2.muscache.com/im/pictures/626d4b1f-6... https://a2.muscache.com/ac/pictures/626d4b1f-6... https://a2.muscache.com/ac/pictures/626d4b1f-6... 46566046 https://www.airbnb.com/users/show/46566046 Glen 2015-10-14 Seattle, Washington, United States I am a 58 year old male that is married to Mag... within an hour 100% 100% f https://a2.muscache.com/ac/pictures/d7e59b0d-8... https://a2.muscache.com/ac/pictures/d7e59b0d-8... Portage Bay 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'jum... t t Fuhrman Avenue East, Seattle, WA 98102, United... Portage Bay Portage Bay Capitol Hill Seattle WA 98102 Seattle Seattle, WA US United States 47.649552 -122.318309 t Apartment Entire home/apt 4 1.0 1.0 2.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $79.00 NaN NaN $500.00 $50.00 3 $25.00 2 29 2 days ago t 6 26 44 273 2016-01-04 2 2015-12-18 2015-12-24 100.0 10.0 10.0 10.0 10.0 10.0 10.0 f NaN WASHINGTON f moderate f f 1 2.00
3815 10267360 https://www.airbnb.com/rooms/10267360 20160104002432 2016-01-04 Private apartment view of Lake WA Very comfortable lower unit. Quiet, charming m... NaN Very comfortable lower unit. Quiet, charming m... none NaN NaN NaN https://a2.muscache.com/ac/pictures/a5974f04-2... https://a2.muscache.com/im/pictures/a5974f04-2... https://a2.muscache.com/ac/pictures/a5974f04-2... https://a2.muscache.com/ac/pictures/a5974f04-2... 52791370 https://www.airbnb.com/users/show/52791370 Virginia 2015-12-30 US NaN NaN NaN NaN f https://a2.muscache.com/ac/pictures/efc75826-1... https://a2.muscache.com/ac/pictures/efc75826-1... NaN 1.0 1.0 ['phone'] t f South Laurel Street, Seattle, WA 98178, United... NaN Rainier Beach Rainier Valley Seattle WA 98178 Seattle Seattle, WA US United States 47.508453 -122.240607 f House Entire home/apt 2 1.0 1.0 1.0 Real Bed {"Cable TV","Wireless Internet",Kitchen,"Free ... NaN $93.00 $450.00 NaN $250.00 $35.00 2 $20.00 1 7 4 days ago t 29 59 88 88 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f moderate f f 1 NaN
3816 9604740 https://www.airbnb.com/rooms/9604740 20160104002432 2016-01-04 Amazing View with Modern Comfort! Cozy studio condo in the heart on Madison Park... Fully furnished unit to accommodate most needs... Cozy studio condo in the heart on Madison Park... none Madison Park offers a peaceful slow pace upsca... NaN Yes https://a2.muscache.com/ac/pictures/202e4ad6-b... https://a2.muscache.com/im/pictures/202e4ad6-b... https://a2.muscache.com/ac/pictures/202e4ad6-b... https://a2.muscache.com/ac/pictures/202e4ad6-b... 25522052 https://www.airbnb.com/users/show/25522052 Karen 2015-01-03 Tacoma, Washington, United States NaN within an hour 100% NaN f https://a0.muscache.com/ac/users/25522052/prof... https://a0.muscache.com/ac/users/25522052/prof... NaN 1.0 1.0 ['email', 'phone', 'facebook', 'reviews', 'kba'] t t 43rd Avenue East, Seattle, WA 98112, United St... NaN Madison Park Capitol Hill Seattle WA 98112 Seattle Seattle, WA US United States 47.632335 -122.275530 f Condominium Entire home/apt 2 1.0 0.0 1.0 Real Bed {TV,"Wireless Internet",Kitchen,"Free Parking ... NaN $99.00 NaN NaN $300.00 $45.00 1 $0.00 3 1125 never t 30 60 90 179 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f moderate f f 1 NaN
3817 10208623 https://www.airbnb.com/rooms/10208623 20160104002432 2016-01-04 Large Lakefront Apartment All hardwood floors, fireplace, 65" TV with Xb... NaN All hardwood floors, fireplace, 65" TV with Xb... none NaN Also our puppy will be boarded away. NaN https://a2.muscache.com/ac/pictures/596705b3-0... https://a2.muscache.com/im/pictures/596705b3-0... https://a2.muscache.com/ac/pictures/596705b3-0... https://a2.muscache.com/ac/pictures/596705b3-0... 14703116 https://www.airbnb.com/users/show/14703116 Gil 2014-04-25 Seattle, Washington, United States NaN within a day 100% NaN f https://a2.muscache.com/ac/pictures/8864f979-b... https://a2.muscache.com/ac/pictures/8864f979-b... Queen Anne 1.0 1.0 ['email', 'phone', 'reviews', 'kba'] t t Westlake Avenue North, Seattle, WA 98109, Unit... Queen Anne East Queen Anne Queen Anne Seattle WA 98109 Seattle Seattle, WA US United States 47.641186 -122.342085 t Apartment Entire home/apt 3 1.5 2.0 1.0 Real Bed {TV,"Cable TV",Internet,"Wireless Internet",Ki... NaN $87.00 NaN NaN NaN NaN 1 $0.00 1 1125 a week ago t 7 7 7 7 2016-01-04 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN f NaN WASHINGTON f flexible f f 1 NaN

3818 rows × 92 columns

In [5]:
listings.describe()
Out[5]:
id scrape_id host_id host_listings_count host_total_listings_count latitude longitude accommodates bathrooms bedrooms beds square_feet guests_included minimum_nights maximum_nights availability_30 availability_60 availability_90 availability_365 number_of_reviews review_scores_rating review_scores_accuracy review_scores_cleanliness review_scores_checkin review_scores_communication review_scores_location review_scores_value license calculated_host_listings_count reviews_per_month
count 3.818000e+03 3.818000e+03 3.818000e+03 3816.000000 3816.000000 3818.000000 3818.000000 3818.000000 3802.000000 3812.000000 3817.000000 97.000000 3818.000000 3818.000000 3818.000000 3818.000000 3818.000000 3818.000000 3818.000000 3818.000000 3171.000000 3160.000000 3165.000000 3160.000000 3167.000000 3163.000000 3162.000000 0.0 3818.000000 3191.000000
mean 5.550111e+06 2.016010e+13 1.578556e+07 7.157757 7.157757 47.628961 -122.333103 3.349398 1.259469 1.307712 1.735394 854.618557 1.672603 2.369303 780.447617 16.786276 36.814825 58.082504 244.772656 22.223415 94.539262 9.636392 9.556398 9.786709 9.809599 9.608916 9.452245 NaN 2.946307 2.078919
std 2.962660e+06 0.000000e+00 1.458382e+07 28.628149 28.628149 0.043052 0.031745 1.977599 0.590369 0.883395 1.139480 671.404893 1.311040 16.305902 1683.589007 12.173637 23.337541 34.063845 126.772526 37.730892 6.606083 0.698031 0.797274 0.595499 0.568211 0.629053 0.750259 NaN 5.893029 1.822348
min 3.335000e+03 2.016010e+13 4.193000e+03 1.000000 1.000000 47.505088 -122.417219 1.000000 0.000000 0.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 0.000000 0.000000 0.000000 0.000000 20.000000 2.000000 3.000000 2.000000 2.000000 4.000000 2.000000 NaN 1.000000 0.020000
25% 3.258256e+06 2.016010e+13 3.275204e+06 1.000000 1.000000 47.609418 -122.354320 2.000000 1.000000 1.000000 1.000000 420.000000 1.000000 1.000000 60.000000 2.000000 13.000000 28.000000 124.000000 2.000000 93.000000 9.000000 9.000000 10.000000 10.000000 9.000000 9.000000 NaN 1.000000 0.695000
50% 6.118244e+06 2.016010e+13 1.055814e+07 1.000000 1.000000 47.623601 -122.328874 3.000000 1.000000 1.000000 1.000000 750.000000 1.000000 2.000000 1125.000000 20.000000 46.000000 73.000000 308.000000 9.000000 96.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 NaN 1.000000 1.540000
75% 8.035127e+06 2.016010e+13 2.590309e+07 3.000000 3.000000 47.662694 -122.310800 4.000000 1.000000 2.000000 2.000000 1200.000000 2.000000 2.000000 1125.000000 30.000000 59.000000 89.000000 360.000000 26.000000 99.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 NaN 2.000000 3.000000
max 1.034016e+07 2.016010e+13 5.320861e+07 502.000000 502.000000 47.733358 -122.240607 16.000000 8.000000 7.000000 15.000000 3000.000000 15.000000 1000.000000 100000.000000 30.000000 60.000000 90.000000 365.000000 474.000000 100.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 NaN 37.000000 12.150000
In [6]:
reviews
Out[6]:
listing_id id date reviewer_id reviewer_name comments
0 7202016 38917982 2015-07-19 28943674 Bianca Cute and cozy place. Perfect location to every...
1 7202016 39087409 2015-07-20 32440555 Frank Kelly has a great room in a very central locat...
2 7202016 39820030 2015-07-26 37722850 Ian Very spacious apartment, and in a great neighb...
3 7202016 40813543 2015-08-02 33671805 George Close to Seattle Center and all it has to offe...
4 7202016 41986501 2015-08-10 34959538 Ming Kelly was a great host and very accommodating ...
5 7202016 43979139 2015-08-23 1154501 Barent Kelly was great, place was great, just what I ...
6 7202016 45265631 2015-09-01 37853266 Kevin Kelly was great! Very nice and the neighborhoo...
7 7202016 46749120 2015-09-13 24445447 Rick hola all bnb erz - Just left Seattle where I h...
8 7202016 47783346 2015-09-21 249583 Todd Kelly's place is conveniently located on a qui...
9 7202016 48388999 2015-09-26 38110731 Tatiana The place was really nice, clean, and the most...
10 7202016 49441269 2015-10-04 39852826 Tim The place was really nice, clean and quiet at ...
11 7202016 50490194 2015-10-12 384855 Tony The listing was exactly as described! Kelly's...
12 7202016 53862449 2015-11-13 21607838 Jason Very welcoming and a nicer place to live in th...
13 7202016 54562283 2015-11-21 17052263 Don Great location, great price, great host! Thank...
14 7202016 55212826 2015-11-29 4774006 Vivian Staying at Kelly's was easy. The location was ...
15 7202016 58268184 2016-01-02 41297839 Travis Kelly was an amazing host who made the stay ve...
16 3946674 20798623 2014-10-05 9313038 Angeline Despite our late booking request, Rachel & Jon...
17 3946674 21224862 2014-10-13 8385649 Celine Rachel & Jon have a nice house closed to downt...
18 3946674 22877803 2014-11-16 9403201 Rémy Rachel and Jon have been the perfect hosts for...
19 3946674 22938377 2014-11-17 2920596 Jason This house was a delightful bright place to st...
20 3946674 23416253 2014-11-30 23579299 Margit Beautiful place, nice neighborhood and lovely ...
21 3946674 23463915 2014-12-01 20706964 Ashley Super cozy home. Located near some good restau...
22 3946674 23709531 2014-12-08 23941301 Tim Cute house, and Rachel and Jon were super nice...
23 3946674 23961948 2014-12-15 7008965 Gabriel Rachel and Jon were really great hosts. Warm, ...
24 3946674 24118813 2014-12-20 24025530 Davi The house was easy to locate and the arrangeme...
25 3946674 24302648 2014-12-25 23834617 Tim Rachel and Jon were very obliging hosts, super...
26 3946674 25275185 2015-01-11 11109842 Michelle What a great stay at Rachel and Jon's! They we...
27 3946674 26338015 2015-02-09 9997395 Jack We had an amazing time and felt very welcome i...
28 3946674 27110794 2015-02-25 4920230 Adrienne It was very easy to get in touch with Rachel t...
29 3946674 27182900 2015-02-27 3002880 Sasha Rachel and Jon's home is beautiful and inspiri...
... ... ... ... ... ... ...
84819 3424991 44496259 2015-08-26 42076842 Xu I had a good experience staying with Michael a...
84820 3424991 46558529 2015-09-11 1339330 Timothy This was a great place to stay. First off it ...
84821 3424991 47823159 2015-09-21 7583246 Jonah Awesome location and price. The apartment was ...
84822 3424991 48593190 2015-09-27 30353275 Emiliano Nice neighbourhood and warm welcome.
84823 3424991 49062311 2015-09-30 26501715 Bronwyn Great location. I was a little scared to enter...
84824 3424991 52847610 2015-11-02 40018387 Jameson & Michelle My boyfriend and I had a great experience stay...
84825 3424991 54116274 2015-11-16 21979218 Liam Had a great stay. Michael and Leah made it re...
84826 3424991 54757263 2015-11-23 30703249 Julia We had a good stay at Michael. He and Leah pro...
84827 3424991 55074633 2015-11-27 26327758 Tangwei In big city, it is very hard to find a clean r...
84828 1179538 54492069 2015-11-20 49301240 Francesca I was searching for a place last minute for my...
84829 1179538 55507128 2015-12-01 49230937 Natalie Very nice apartment, clean and quite.
84830 3624990 20029700 2014-09-22 6074769 Christie The location is super convenient to the state ...
84831 3624990 23031040 2014-11-21 19473144 Megan This apartment is in a great location - easy w...
84832 3624990 27384730 2015-03-03 23852813 Justine Absolutely perfect stay! Doug & Rebecca were s...
84833 3624990 28773963 2015-03-30 13891549 Cyanide & Happniess Excellent room, very attentive property manage...
84834 3624990 29827002 2015-04-13 5703826 Janice Great, clean place in a perfect location for a...
84835 3624990 31793991 2015-05-10 13052628 Jordan What an amazing place to stay in Seattle! A fe...
84836 3624990 32446221 2015-05-18 24660858 Colleen We had an excellent stay at Seattle Suites! Th...
84837 3624990 32954604 2015-05-24 22378313 Ryan The apartment was clean and accurate to the de...
84838 3624990 35297846 2015-06-17 2457555 Sharon We were warmly greeted by Doug at the time agr...
84839 3624990 36782055 2015-07-01 33029028 Simon The apartment was clean, tidy and as described...
84840 3624990 42509459 2015-08-14 1329969 Joke We were with 7 people in rebecca's two 2-bed a...
84841 3624990 46118182 2015-09-08 2005229 Brandon Great place in the middle of the city. Easy to...
84842 3624990 49000780 2015-09-30 21815461 Kellye We loved how close it was to the Convention Ce...
84843 3624990 49768901 2015-10-06 37578535 Michael Comfortability upon arrival and everything wit...
84844 3624990 50436321 2015-10-12 37419458 Ryan The description and pictures of the apartment ...
84845 3624990 51024875 2015-10-17 6933252 Linda We had an excellent stay. It was clean and com...
84846 3624990 51511988 2015-10-20 19543701 Jaime Gran ubicación, cerca de todo lo atractivo del...
84847 3624990 52814482 2015-11-02 24445024 Jørgen Very good apartement, clean and well sized. Si...
84848 9727246 56429621 2015-12-13 30860360 Stephanie Breanne was a great host. Check in was easy, s...

84849 rows × 6 columns

In [7]:
review_scores = ['id', 'review_scores_rating', 'review_scores_accuracy', 'review_scores_cleanliness', 'review_scores_checkin', 'review_scores_communication', 'review_scores_location', 'review_scores_value', 'number_of_reviews']
In [8]:
listings_reviews = listings[review_scores]
In [9]:
listings_reviews
Out[9]:
id review_scores_rating review_scores_accuracy review_scores_cleanliness review_scores_checkin review_scores_communication review_scores_location review_scores_value number_of_reviews
0 241032 95.0 10.0 10.0 10.0 10.0 9.0 10.0 207
1 953595 96.0 10.0 10.0 10.0 10.0 10.0 10.0 43
2 3308979 97.0 10.0 10.0 10.0 10.0 10.0 10.0 20
3 7421966 NaN NaN NaN NaN NaN NaN NaN 0
4 278830 92.0 9.0 9.0 10.0 10.0 9.0 9.0 38
5 5956968 95.0 10.0 10.0 10.0 10.0 10.0 10.0 17
6 1909058 99.0 10.0 10.0 10.0 10.0 10.0 10.0 58
7 856550 97.0 10.0 10.0 10.0 10.0 9.0 10.0 173
8 4948745 97.0 10.0 9.0 10.0 9.0 10.0 10.0 8
9 2493658 97.0 10.0 10.0 10.0 10.0 10.0 9.0 32
10 175576 97.0 10.0 10.0 10.0 10.0 10.0 10.0 181
11 4454295 97.0 10.0 10.0 9.0 10.0 10.0 9.0 8
12 3883392 98.0 10.0 10.0 10.0 10.0 10.0 10.0 13
13 8889257 100.0 10.0 10.0 9.0 9.0 10.0 10.0 3
14 5680462 98.0 9.0 10.0 10.0 10.0 10.0 10.0 18
15 8988178 80.0 8.0 10.0 8.0 8.0 8.0 8.0 1
16 3245876 95.0 10.0 9.0 10.0 10.0 10.0 9.0 84
17 4933447 98.0 10.0 10.0 10.0 10.0 10.0 10.0 45
18 7735464 NaN NaN NaN NaN NaN NaN NaN 0
19 6291829 85.0 10.0 9.0 9.0 9.0 8.0 8.0 5
20 9218403 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
21 4125779 84.0 9.0 9.0 9.0 9.0 10.0 8.0 11
22 8942678 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
23 10106055 NaN NaN NaN NaN NaN NaN NaN 0
24 6362362 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
25 3544550 100.0 10.0 10.0 9.0 10.0 10.0 10.0 8
26 9025039 NaN NaN NaN NaN NaN NaN NaN 0
27 3200646 95.0 10.0 10.0 10.0 10.0 9.0 9.0 80
28 8859380 100.0 10.0 10.0 10.0 10.0 10.0 10.0 6
29 4520099 85.0 8.0 9.0 7.0 10.0 9.0 9.0 4
... ... ... ... ... ... ... ... ... ...
3788 7745196 99.0 10.0 10.0 10.0 10.0 10.0 10.0 14
3789 4645405 90.0 9.0 9.0 9.0 10.0 9.0 9.0 23
3790 2755730 98.0 10.0 10.0 10.0 10.0 10.0 10.0 75
3791 7949448 100.0 10.0 10.0 10.0 10.0 10.0 10.0 11
3792 9288840 NaN NaN NaN NaN NaN NaN NaN 0
3793 3312406 98.0 10.0 10.0 10.0 10.0 10.0 10.0 78
3794 6621924 90.0 9.0 9.0 10.0 10.0 9.0 8.0 21
3795 5673552 98.0 10.0 10.0 10.0 10.0 10.0 10.0 10
3796 609701 98.0 10.0 10.0 10.0 10.0 10.0 10.0 233
3797 10118341 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
3798 2614387 98.0 10.0 10.0 10.0 10.0 10.0 10.0 128
3799 7735100 95.0 10.0 9.0 10.0 10.0 10.0 10.0 5
3800 5482204 NaN NaN NaN NaN NaN NaN NaN 0
3801 4524575 100.0 10.0 10.0 10.0 10.0 10.0 10.0 28
3802 8562314 NaN NaN NaN NaN NaN NaN NaN 0
3803 9698202 95.0 10.0 10.0 10.0 10.0 10.0 10.0 4
3804 7178490 95.0 10.0 10.0 10.0 10.0 10.0 10.0 12
3805 8054902 98.0 10.0 10.0 10.0 10.0 10.0 10.0 10
3806 5458027 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
3807 4940491 97.0 10.0 10.0 10.0 10.0 10.0 9.0 7
3808 1844791 96.0 10.0 9.0 10.0 10.0 10.0 9.0 29
3809 6120046 80.0 8.0 7.0 9.0 9.0 9.0 8.0 10
3810 262764 92.0 9.0 8.0 10.0 10.0 10.0 8.0 5
3811 8578490 100.0 9.0 8.0 10.0 10.0 10.0 10.0 2
3812 3383329 96.0 10.0 10.0 10.0 10.0 9.0 10.0 73
3813 8101950 80.0 8.0 10.0 4.0 8.0 10.0 8.0 1
3814 8902327 100.0 10.0 10.0 10.0 10.0 10.0 10.0 2
3815 10267360 NaN NaN NaN NaN NaN NaN NaN 0
3816 9604740 NaN NaN NaN NaN NaN NaN NaN 0
3817 10208623 NaN NaN NaN NaN NaN NaN NaN 0

3818 rows × 9 columns

In [10]:
listings_reviews.describe()
Out[10]:
id review_scores_rating review_scores_accuracy review_scores_cleanliness review_scores_checkin review_scores_communication review_scores_location review_scores_value number_of_reviews
count 3.818000e+03 3171.000000 3160.000000 3165.000000 3160.000000 3167.000000 3163.000000 3162.000000 3818.000000
mean 5.550111e+06 94.539262 9.636392 9.556398 9.786709 9.809599 9.608916 9.452245 22.223415
std 2.962660e+06 6.606083 0.698031 0.797274 0.595499 0.568211 0.629053 0.750259 37.730892
min 3.335000e+03 20.000000 2.000000 3.000000 2.000000 2.000000 4.000000 2.000000 0.000000
25% 3.258256e+06 93.000000 9.000000 9.000000 10.000000 10.000000 9.000000 9.000000 2.000000
50% 6.118244e+06 96.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 9.000000
75% 8.035127e+06 99.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 26.000000
max 1.034016e+07 100.000000 10.000000 10.000000 10.000000 10.000000 10.000000 10.000000 474.000000
In [11]:
listings_reviews.dropna(inplace=True)
/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

In [12]:
listings_reviews
Out[12]:
id review_scores_rating review_scores_accuracy review_scores_cleanliness review_scores_checkin review_scores_communication review_scores_location review_scores_value number_of_reviews
0 241032 95.0 10.0 10.0 10.0 10.0 9.0 10.0 207
1 953595 96.0 10.0 10.0 10.0 10.0 10.0 10.0 43
2 3308979 97.0 10.0 10.0 10.0 10.0 10.0 10.0 20
4 278830 92.0 9.0 9.0 10.0 10.0 9.0 9.0 38
5 5956968 95.0 10.0 10.0 10.0 10.0 10.0 10.0 17
6 1909058 99.0 10.0 10.0 10.0 10.0 10.0 10.0 58
7 856550 97.0 10.0 10.0 10.0 10.0 9.0 10.0 173
8 4948745 97.0 10.0 9.0 10.0 9.0 10.0 10.0 8
9 2493658 97.0 10.0 10.0 10.0 10.0 10.0 9.0 32
10 175576 97.0 10.0 10.0 10.0 10.0 10.0 10.0 181
11 4454295 97.0 10.0 10.0 9.0 10.0 10.0 9.0 8
12 3883392 98.0 10.0 10.0 10.0 10.0 10.0 10.0 13
13 8889257 100.0 10.0 10.0 9.0 9.0 10.0 10.0 3
14 5680462 98.0 9.0 10.0 10.0 10.0 10.0 10.0 18
15 8988178 80.0 8.0 10.0 8.0 8.0 8.0 8.0 1
16 3245876 95.0 10.0 9.0 10.0 10.0 10.0 9.0 84
17 4933447 98.0 10.0 10.0 10.0 10.0 10.0 10.0 45
19 6291829 85.0 10.0 9.0 9.0 9.0 8.0 8.0 5
20 9218403 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
21 4125779 84.0 9.0 9.0 9.0 9.0 10.0 8.0 11
22 8942678 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
24 6362362 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
25 3544550 100.0 10.0 10.0 9.0 10.0 10.0 10.0 8
27 3200646 95.0 10.0 10.0 10.0 10.0 9.0 9.0 80
28 8859380 100.0 10.0 10.0 10.0 10.0 10.0 10.0 6
29 4520099 85.0 8.0 9.0 7.0 10.0 9.0 9.0 4
30 2481869 96.0 10.0 10.0 10.0 10.0 10.0 10.0 38
31 1110749 92.0 9.0 9.0 10.0 9.0 10.0 9.0 68
32 5978498 88.0 9.0 9.0 9.0 9.0 10.0 9.0 8
33 5021081 75.0 8.0 9.0 8.0 9.0 9.0 8.0 5
... ... ... ... ... ... ... ... ... ...
3782 4100009 97.0 10.0 10.0 10.0 10.0 10.0 10.0 41
3783 4738971 88.0 9.0 9.0 10.0 9.0 10.0 9.0 22
3784 692671 95.0 10.0 10.0 10.0 10.0 9.0 10.0 50
3785 5893969 96.0 10.0 10.0 10.0 10.0 10.0 10.0 5
3786 215954 98.0 10.0 9.0 10.0 10.0 10.0 10.0 19
3787 2494157 98.0 10.0 10.0 10.0 10.0 10.0 9.0 8
3788 7745196 99.0 10.0 10.0 10.0 10.0 10.0 10.0 14
3789 4645405 90.0 9.0 9.0 9.0 10.0 9.0 9.0 23
3790 2755730 98.0 10.0 10.0 10.0 10.0 10.0 10.0 75
3791 7949448 100.0 10.0 10.0 10.0 10.0 10.0 10.0 11
3793 3312406 98.0 10.0 10.0 10.0 10.0 10.0 10.0 78
3794 6621924 90.0 9.0 9.0 10.0 10.0 9.0 8.0 21
3795 5673552 98.0 10.0 10.0 10.0 10.0 10.0 10.0 10
3796 609701 98.0 10.0 10.0 10.0 10.0 10.0 10.0 233
3797 10118341 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
3798 2614387 98.0 10.0 10.0 10.0 10.0 10.0 10.0 128
3799 7735100 95.0 10.0 9.0 10.0 10.0 10.0 10.0 5
3801 4524575 100.0 10.0 10.0 10.0 10.0 10.0 10.0 28
3803 9698202 95.0 10.0 10.0 10.0 10.0 10.0 10.0 4
3804 7178490 95.0 10.0 10.0 10.0 10.0 10.0 10.0 12
3805 8054902 98.0 10.0 10.0 10.0 10.0 10.0 10.0 10
3806 5458027 100.0 10.0 10.0 10.0 10.0 10.0 10.0 1
3807 4940491 97.0 10.0 10.0 10.0 10.0 10.0 9.0 7
3808 1844791 96.0 10.0 9.0 10.0 10.0 10.0 9.0 29
3809 6120046 80.0 8.0 7.0 9.0 9.0 9.0 8.0 10
3810 262764 92.0 9.0 8.0 10.0 10.0 10.0 8.0 5
3811 8578490 100.0 9.0 8.0 10.0 10.0 10.0 10.0 2
3812 3383329 96.0 10.0 10.0 10.0 10.0 9.0 10.0 73
3813 8101950 80.0 8.0 10.0 4.0 8.0 10.0 8.0 1
3814 8902327 100.0 10.0 10.0 10.0 10.0 10.0 10.0 2

3158 rows × 9 columns

In [13]:
review_scores[1:]
Out[13]:
['review_scores_rating',
 'review_scores_accuracy',
 'review_scores_cleanliness',
 'review_scores_checkin',
 'review_scores_communication',
 'review_scores_location',
 'review_scores_value',
 'number_of_reviews']
In [ ]:
 
In [ ]:
 

Q1: Are Customers Happy?

First, we want to make sure the customer is having good time while staying with AirBNB Host:

In [14]:
fig = go.Figure()
for i in review_scores[2:-1]:
    fig.add_trace(go.Histogram(x=listings_reviews[i],name=i))

# Overlay both histograms
fig.update_layout(title = 'Review Scores For Each Category', barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()

As we can see from the graph above most of the reviews are excellent, which means the customers are happy.

In [ ]:
 

Data preparation:

Here I will clean some features in the listings data set, for further investigations.
I will start by writing a function for host features cleaning.

In [15]:
def clean_host_feature(listings):
    '''
    Description: This function is used to clean and select the features 
                 related to host data in the listings data set.

    Arguments:
        AirBNB listings dataframe.

    Returns:
        Cleaned dataframe with only host related features.
    '''

    host_features = ['host_response_rate', 'host_acceptance_rate', 'host_is_superhost', 'host_thumbnail_url', 'host_picture_url', 'host_neighbourhood', 'host_listings_count', 'host_total_listings_count', 'host_verifications', 'host_has_profile_pic', 'host_identity_verified']
    listings_host_features = listings[host_features]
    listings_host_features['host_thumbnail_url'] = listings_host_features.apply(lambda x: 0 if pd.isna(x['host_thumbnail_url']) else 1, axis=1)
    listings_host_features['host_picture_url'] = listings_host_features.apply(lambda x: 0 if pd.isna(x['host_picture_url']) else 1, axis=1)
    listings_host_features['host_has_profile_pic'] = listings_host_features.apply(lambda x: 1 if x['host_has_profile_pic']=='t' else 0, axis=1)
    listings_host_features['host_identity_verified'] = listings_host_features.apply(lambda x: 1 if x['host_identity_verified']=='t' else 0, axis=1)
    listings_host_features['host_verifications'] = listings_host_features.apply(lambda x: ast.literal_eval(x['host_verifications']), axis=1)
    return listings_host_features
In [16]:
listings_host_features = clean_host_feature(listings)
/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:15: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:16: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:17: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:18: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:19: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

In [17]:
listings_host_features
Out[17]:
host_response_rate host_acceptance_rate host_is_superhost host_thumbnail_url host_picture_url host_neighbourhood host_listings_count host_total_listings_count host_verifications host_has_profile_pic host_identity_verified
0 96% 100% f 1 1 Queen Anne 3.0 3.0 [email, phone, reviews, kba] 1 1
1 98% 100% t 1 1 Queen Anne 6.0 6.0 [email, phone, facebook, linkedin, reviews, ju... 1 1
2 67% 100% f 1 1 Queen Anne 2.0 2.0 [email, phone, google, reviews, jumio] 1 1
3 NaN NaN f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews, jumio] 1 1
4 100% NaN f 1 1 Queen Anne 2.0 2.0 [email, phone, facebook, reviews, kba] 1 1
5 NaN NaN f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
6 100% 100% t 1 1 Queen Anne 1.0 1.0 [email, phone, reviews, kba] 1 1
7 100% 100% t 1 1 Queen Anne 5.0 5.0 [email, phone, facebook, google, linkedin, rev... 1 1
8 NaN 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, linkedin, reviews, kba] 1 1
9 98% 100% t 1 1 Queen Anne 6.0 6.0 [email, phone, facebook, linkedin, reviews, ju... 1 1
10 100% 100% t 1 1 Queen Anne 1.0 1.0 [email, phone, reviews, kba] 1 1
11 100% 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
12 100% 100% t 1 1 NaN 1.0 1.0 [email, phone, linkedin, reviews, jumio] 1 1
13 100% 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, reviews, kba] 1 1
14 100% 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
15 100% 100% f 1 1 NaN 1.0 1.0 [email, reviews, kba] 1 0
16 100% 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, linkedin, reviews, ju... 1 1
17 100% 100% t 1 1 Queen Anne 1.0 1.0 [email, phone, reviews, kba] 1 1
18 NaN NaN f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews, jumio] 1 1
19 NaN NaN f 1 1 Queen Anne 1.0 1.0 [email, phone, linkedin, reviews, kba] 1 1
20 100% 100% f 1 1 NaN 1.0 1.0 [email, phone, reviews, kba] 1 1
21 100% 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews] 1 0
22 100% 100% f 1 1 Queen Anne 1.0 1.0 [phone, reviews] 1 0
23 NaN NaN f 1 1 Queen Anne 1.0 1.0 [phone] 1 0
24 NaN NaN f 1 1 Queen Anne 1.0 1.0 [email, phone, reviews] 1 0
25 67% 100% f 1 1 Queen Anne 2.0 2.0 [email, phone, google, reviews, jumio] 1 1
26 100% 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews, jumio] 1 1
27 100% 100% t 1 1 Queen Anne 5.0 5.0 [email, phone, facebook, google, linkedin, rev... 1 1
28 100% 100% f 1 1 Queen Anne 5.0 5.0 [email, phone, reviews, jumio, kba] 1 1
29 71% 100% f 1 1 Queen Anne 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
... ... ... ... ... ... ... ... ... ... ... ...
3788 100% 100% f 1 1 Fremont 1.0 1.0 [email, phone, google, reviews, kba] 1 1
3789 100% 100% f 1 1 Fremont 2.0 2.0 [email, phone, reviews, kba] 1 1
3790 100% 100% t 1 1 Fremont 1.0 1.0 [email, phone, reviews, kba] 1 1
3791 100% 100% f 1 1 Fremont 1.0 1.0 [email, phone, linkedin, reviews, kba] 1 1
3792 100% NaN f 1 1 Fremont 1.0 1.0 [email, phone, kba] 1 0
3793 100% 100% t 1 1 Fremont 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
3794 80% 100% f 1 1 Fremont 1.0 1.0 [email, phone, reviews, jumio] 1 1
3795 100% 100% t 1 1 NaN 1.0 1.0 [email, phone, facebook, reviews, jumio] 1 1
3796 100% 100% t 1 1 Fremont 1.0 1.0 [email, phone, reviews, jumio] 1 1
3797 100% 100% f 1 1 Fremont 1.0 1.0 [email, phone, linkedin, reviews, kba] 1 1
3798 100% 100% f 1 1 Fremont 2.0 2.0 [email, phone, reviews, kba] 1 1
3799 25% 100% f 1 1 Fremont 1.0 1.0 [email, phone, reviews, kba] 1 1
3800 NaN NaN f 1 1 Fremont 1.0 1.0 [email, phone] 1 0
3801 100% 100% t 1 1 Fremont 1.0 1.0 [email, phone, linkedin, reviews, kba] 1 1
3802 NaN NaN f 1 1 NaN 1.0 1.0 [email, phone] 1 0
3803 97% 100% f 1 1 Queen Anne 9.0 9.0 [email, phone, facebook, linkedin, reviews, ju... 1 1
3804 100% 100% t 1 1 Fremont 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
3805 100% 100% f 1 1 Fremont 1.0 1.0 [email, phone, facebook, linkedin, reviews, ju... 1 1
3806 100% 100% t 1 1 Fremont 2.0 2.0 [email, phone, reviews, jumio] 1 1
3807 100% 100% f 1 1 Wallingford 1.0 1.0 [email, phone, reviews] 1 0
3808 100% 100% f 1 1 Fremont 2.0 2.0 [email, phone, reviews, kba] 1 1
3809 100% 100% f 1 1 Fremont 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
3810 100% 100% f 1 1 Fremont 1.0 1.0 [email, phone, linkedin, reviews, kba] 1 1
3811 100% 100% f 1 1 Fremont 1.0 1.0 [email, phone, reviews, kba] 1 1
3812 100% 100% t 1 1 Fremont 3.0 3.0 [email, phone, facebook, reviews, kba] 1 1
3813 99% 100% f 1 1 Holly 354.0 354.0 [email, phone, linkedin, reviews, jumio] 1 1
3814 100% 100% f 1 1 Portage Bay 1.0 1.0 [email, phone, facebook, reviews, jumio] 1 1
3815 NaN NaN f 1 1 NaN 1.0 1.0 [phone] 1 0
3816 100% NaN f 1 1 NaN 1.0 1.0 [email, phone, facebook, reviews, kba] 1 1
3817 100% NaN f 1 1 Queen Anne 1.0 1.0 [email, phone, reviews, kba] 1 1

3818 rows × 11 columns

Now I will prepare the locations data set:

In [18]:
locations = ['id','latitude', 'longitude', 'neighbourhood', 'street','is_location_exact']
In [19]:
listings_locations = listings[locations]
In [20]:
listings_locations = listings_locations[listings_locations['is_location_exact']=='t'].drop('is_location_exact',axis=1)
In [21]:
listings_locations['listing_id']=listings_locations['id']
In [22]:
listings_locations=listings_locations.drop('id',axis=1)
In [23]:
listings_locations
Out[23]:
latitude longitude neighbourhood street listing_id
0 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032
1 47.639123 -122.365666 Queen Anne 7th Avenue West, Seattle, WA 98119, United States 953595
2 47.629724 -122.369483 Queen Anne West Lee Street, Seattle, WA 98119, United States 3308979
3 47.638473 -122.369279 Queen Anne 8th Avenue West, Seattle, WA 98119, United States 7421966
4 47.632918 -122.372471 Queen Anne 14th Ave W, Seattle, WA 98119, United States 278830
5 47.630525 -122.366174 Queen Anne West Comstock Street, Seattle, WA 98119, Unite... 5956968
6 47.636605 -122.368519 Queen Anne 10th Avenue West, Seattle, WA 98119, United St... 1909058
7 47.640161 -122.375856 Queen Anne West Wheeler Street, Seattle, WA 98119, United... 856550
8 47.632410 -122.357216 Queen Anne Queen Anne Avenue North, Seattle, WA 98109, Un... 4948745
9 47.637492 -122.366889 Queen Anne 7th Avenue West, Seattle, WA 98119, United States 2493658
10 47.635482 -122.358478 Queen Anne 1st Ave W, Seattle, WA 98119, United States 175576
11 47.637214 -122.360046 Queen Anne 3rd Avenue West, Seattle, WA 98119, United States 4454295
12 47.635546 -122.373171 NaN West Howe Street, Seattle, WA 98119, United St... 3883392
13 47.629507 -122.367629 Queen Anne West Prospect Street, Seattle, WA 98119, Unite... 8889257
14 47.639203 -122.365863 Queen Anne 7th Avenue West, Seattle, WA 98119, United States 5680462
16 47.626200 -122.366602 Queen Anne West Mercer Place, Seattle, WA 98119, United S... 3245876
17 47.640646 -122.372406 Queen Anne 12th Avenue West, Seattle, WA 98119, United St... 4933447
18 47.639776 -122.372235 Queen Anne 11th Avenue West, Seattle, WA 98119, United St... 7735464
19 47.636025 -122.358694 Queen Anne 1st Avenue West, Seattle, WA 98119, United States 6291829
21 47.636374 -122.361033 Queen Anne 2nd Avenue West, Seattle, WA 98119, United States 4125779
22 47.635632 -122.358881 Queen Anne 1st Avenue West, Seattle, WA 98119, United States 8942678
23 47.633394 -122.371920 Queen Anne West Galer Street, Seattle, WA 98119, United S... 10106055
24 47.638517 -122.369581 Queen Anne 10th Avenue West, Seattle, WA 98119, United St... 6362362
25 47.631397 -122.367767 Queen Anne 7th Avenue West, Seattle, WA 98119, United States 3544550
26 47.638752 -122.367973 Queen Anne West McGraw Street, Seattle, WA 98119, United ... 9025039
27 47.639266 -122.374726 Queen Anne West Wheeler Street, Seattle, WA 98119, United... 3200646
28 47.629907 -122.368948 Queen Anne 9th Avenue West, Seattle, WA 98119, United States 8859380
29 47.639816 -122.374338 Queen Anne 14th Avenue West, Seattle, WA 98119, United St... 4520099
30 47.639008 -122.365320 Queen Anne 7th Avenue West, Seattle, WA 98119, United States 2481869
31 47.635085 -122.364443 Queen Anne 5th Avenue West, Seattle, WA 98119, United States 1110749
... ... ... ... ... ...
3784 47.660342 -122.364747 Fremont NW 50th St, Seattle, WA 98107, United States 692671
3785 47.653176 -122.346211 Fremont Bridge Way North, Seattle, WA 98103, United St... 5893969
3786 47.661396 -122.352256 Fremont Dayton Ave N, Seattle, WA 98103, United States 215954
3787 47.658552 -122.348265 Fremont Linden Avenue North, Seattle, WA 98103, United... 2494157
3788 47.656739 -122.344865 Fremont Woodland Park Avenue North, Seattle, WA 98103,... 7745196
3789 47.661171 -122.349923 Fremont North 46th Street, Seattle, WA 98103, United S... 4645405
3790 47.649271 -122.347817 Fremont North 35th Street, Seattle, WA 98103, United S... 2755730
3791 47.659149 -122.363466 Fremont 6th Avenue Northwest, Seattle, WA 98107, Unite... 7949448
3792 47.663040 -122.348499 Fremont North 46th Street, Seattle, WA 98103, United S... 9288840
3793 47.660056 -122.357683 Fremont Baker Avenue Northwest, Seattle, WA 98107, Uni... 3312406
3794 47.654199 -122.359987 Fremont Northwest Bowdoin Place, Seattle, WA 98107, Un... 6621924
3796 47.656508 -122.360571 Fremont NW 40th St, Seattle, WA 98107, United States 609701
3797 47.658976 -122.354915 Fremont Phinney Avenue North, Seattle, WA 98103, Unite... 10118341
3798 47.655381 -122.343205 Fremont Midvale Avenue North, Seattle, WA 98103, Unite... 2614387
3799 47.652902 -122.352110 Fremont Dayton Avenue North, Seattle, WA 98103, United... 7735100
3800 47.663613 -122.349519 Fremont Linden Avenue North, Seattle, WA 98103, United... 5482204
3801 47.657078 -122.358795 Fremont 1st Avenue Northwest, Seattle, WA 98107, Unite... 4524575
3803 47.661131 -122.349238 Fremont Linden Avenue North, Seattle, WA 98103, United... 9698202
3804 47.660856 -122.352401 Fremont N 44th st, Seattle, WA 98103, United States 7178490
3805 47.653158 -122.356285 Fremont 1st Avenue Northwest, Seattle, WA 98107, Unite... 8054902
3806 47.656057 -122.354514 Fremont Greenwood Avenue North, Seattle, WA 98103, Uni... 5458027
3807 47.654304 -122.342720 Wallingford Stone Way North, Seattle, WA 98103, United States 4940491
3808 47.662036 -122.350485 Fremont Dayton Avenue North, Seattle, WA 98103, United... 1844791
3809 47.648689 -122.343915 Fremont Albion Place North, Seattle, WA 98103, United ... 6120046
3810 47.654205 -122.352604 Fremont N Bowdoin Pl, Seattle, WA 98103, United States 262764
3811 47.657898 -122.346692 Fremont Whitman Avenue North, Seattle, WA 98103, Unite... 8578490
3812 47.654516 -122.358124 Fremont Northwest 39th Street, Seattle, WA 98107, Unit... 3383329
3813 47.664295 -122.359170 Fremont Northwest 48th Street, Seattle, WA 98107, Unit... 8101950
3814 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327
3817 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623

3412 rows × 5 columns

Q2: Where listings are concentrated?

Second, we want to know what neighbourhoods are most popular.

In [24]:
fig = go.Figure()
fig.add_trace(go.Histogram(x=listings_locations['neighbourhood'],name='neighbourhood'))

# Overlay both histograms
fig.update_layout(title = 'Seattle AirBNB Listings Distribution Per Neighbourhood', barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()
In [25]:
listings_locations.groupby('neighbourhood')['neighbourhood'].count().nlargest()
Out[25]:
neighbourhood
Capitol Hill    341
Ballard         208
Minor           189
Belltown        185
Queen Anne      185
Name: neighbourhood, dtype: int64

The most popular listings neighbourhood is: Capitol Hill.
Then almost equally popular: Ballard, Minor, Belltown, Queen Anne

In [26]:
fig = go.Figure(data=go.Scattergeo(
        lon = listings_locations['longitude'],
        lat = listings_locations['latitude'],
        text = listings_locations['neighbourhood'],
        ))

fig.update_layout(
        title = 'Seattle AirBNB Listings Locations Map',
        geo_scope='usa',
    )
fig.show()

Q3: How much the customer is paying to stay in Seattle with AirBNB?

Then, we will explore the price distribution for Seattle listing.

In [27]:
calendar['price']
Out[27]:
0          $85.00
1          $85.00
2             NaN
3             NaN
4             NaN
5             NaN
6             NaN
7             NaN
8             NaN
9          $85.00
10         $85.00
11            NaN
12            NaN
13            NaN
14         $85.00
15         $85.00
16         $85.00
17            NaN
18            NaN
19            NaN
20         $85.00
21         $85.00
22         $85.00
23         $85.00
24         $85.00
25            NaN
26            NaN
27            NaN
28         $85.00
29         $85.00
            ...  
1393540       NaN
1393541       NaN
1393542       NaN
1393543       NaN
1393544       NaN
1393545       NaN
1393546       NaN
1393547       NaN
1393548       NaN
1393549       NaN
1393550       NaN
1393551       NaN
1393552       NaN
1393553       NaN
1393554       NaN
1393555       NaN
1393556       NaN
1393557       NaN
1393558       NaN
1393559       NaN
1393560       NaN
1393561       NaN
1393562       NaN
1393563       NaN
1393564       NaN
1393565       NaN
1393566       NaN
1393567       NaN
1393568       NaN
1393569       NaN
Name: price, Length: 1393570, dtype: object
In [28]:
prices = calendar.dropna()
prices['price'] = prices.apply(lambda x: float(x['price'].replace('$','').replace(',','')), axis=1)
/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

In [29]:
fig = go.Figure()
fig.add_trace(go.Histogram(x=prices['price'],name='price'))

# Overlay both histograms
fig.update_layout(title = 'Seattle AirBNB Listing Price Distribution',barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()
In [30]:
prices['price'].describe()
Out[30]:
count    934542.000000
mean        137.944859
std         105.062870
min          10.000000
25%          75.000000
50%         109.000000
75%         160.000000
max        1650.000000
Name: price, dtype: float64

it is clear that the average price is 137, with highest count for 150 range

Q4: What are the average prices for each neighborhood?

Then, we will explore the price distribution for each neighbourhood.

In [31]:
listings_locations_calendar_merged = pd.merge(listings_locations , calendar, on='listing_id', how='outer').dropna()
In [32]:
listings_locations_calendar_merged = listings_locations_calendar_merged[listings_locations_calendar_merged['available']=='t'].drop(['date','available'],axis=1)
In [33]:
listings_locations_calendar_merged['price'] = listings_locations_calendar_merged.apply(lambda x: float(x['price'].replace('$','').replace(',','')), axis=1)
In [34]:
listings_locations_calendar_merged
Out[34]:
latitude longitude neighbourhood street listing_id price
0 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
1 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
9 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
10 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
14 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
15 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
16 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
20 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
21 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
22 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
23 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
24 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
28 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
29 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
30 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
31 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
32 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
33 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
34 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
35 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
36 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
37 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
41 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
42 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
43 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
44 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
45 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
46 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
47 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
48 47.636289 -122.371025 Queen Anne Gilman Dr W, Seattle, WA 98119, United States 241032 85.0
... ... ... ... ... ... ...
1244992 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1244993 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1244994 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1244995 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1244996 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1244997 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 125.0
1244998 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 125.0
1244999 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245000 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245001 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245002 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245003 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245004 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 125.0
1245005 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 125.0
1245006 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245007 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245008 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245009 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245010 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245011 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 125.0
1245012 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 125.0
1245013 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245014 47.649552 -122.318309 Portage Bay Fuhrman Avenue East, Seattle, WA 98102, United... 8902327 79.0
1245015 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623 87.0
1245016 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623 87.0
1245017 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623 87.0
1245018 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623 87.0
1245021 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623 87.0
1245022 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623 87.0
1245023 47.641186 -122.342085 Queen Anne Westlake Avenue North, Seattle, WA 98109, Unit... 10208623 87.0

808718 rows × 6 columns

In [35]:
df = listings_locations_calendar_merged.groupby('neighbourhood').mean()
fig = px.bar(df, y=df.price, x=df.index, text=df.price)
fig.update_traces(texttemplate='%{text:.2s}', textposition='outside')
fig.update_layout(title = 'Seattle AirBNB Listing Average Prices For Each Neighbourhood', uniformtext_minsize=8, uniformtext_mode='hide')
fig.show()
In [36]:
listings_locations_calendar_merged.groupby('neighbourhood')['price'].mean().nlargest(50)
Out[36]:
neighbourhood
Portage Bay                  250.885285
Industrial District          245.875441
Windermere                   227.516092
Alki                         226.410733
Westlake                     225.336634
Central Business District    210.509103
Fauntleroy                   205.882353
Magnolia                     205.523503
Pike Place Market            204.686803
Belltown                     201.061400
Pike Market                  192.582019
Queen Anne                   190.648790
South Lake Union             186.288490
Pinehurst                    181.668142
Madrona                      166.367724
Green Lake                   164.928139
Montlake                     163.139629
Lower Queen Anne             158.929664
First Hill                   155.947990
North Admiral                155.736659
Pioneer Square               154.067182
Madison Park                 145.502389
Fremont                      141.962528
Seaview                      141.670207
Yesler Terrace               141.037221
Minor                        135.778037
Capitol Hill                 135.456855
Broadway                     134.753425
Leschi                       133.423488
Wallingford                  131.802042
South Beacon Hill            131.321212
South Park                   128.338863
Arbor Heights                127.230769
Phinney Ridge                126.478765
Harrison/Denny-Blaine        126.464454
Ballard                      125.943331
Atlantic                     125.779920
View Ridge                   124.224777
North Beach/Blue Ridge       122.300155
Haller Lake                  121.955873
Genesee                      121.610086
Gatewood                     118.250151
Cedar Park                   118.203544
Roosevelt                    117.941571
International District       116.072308
Ravenna                      115.721137
Stevens                      115.673542
Laurelhurst                  114.084595
Interbay                     113.081671
Eastlake                     111.225513
Name: price, dtype: float64

The most expensive listings neighbourhoods are: Portage Bay and Industrial District .
Then almost equally expensive: Alki,Westlake and Central Business District

Results and Evaluation:

The most expensive listings neighbourhoods are not the most popular listings. Popular listings are more in the mid range prices like the most popular listing Capitol Hill, which hase mean price of 135.

In [ ]: